Summing Up Enum List Selection

[Aditya_K1999]

I have below tables:

1. Service Details: Contains all services with price & other different attributes.
2. Service Availed: Is the table where I basically select the services I want to book.

So, service availed table has a field by the name of service name which is of enum data type. I want the sum of service charge from the service details table for only the services selected in the service availed table, keeping in mind the pet size & pet coat in mind.

I tried the below formula, ignoring the pet size and pet coat attribute for now just to see if I am able to atleast get a sum, but it didnt work.

SUM(
SELECT(
Service Details[Service Charge],
IN([Service Name],[_THISROW].[Service Name])))

Can someone help?

[Jack_Bates]

It may be wise to create virtual columns for each of the charges and then create a virtual columns with a sum of “Charges” by the date or ID for service details.

SUM(SELECT([Service Details][AMOUNT], [Service Charge] = “Pet Coat”))

SUM(SELECT([Service Charges][AMOUNT], TRUE))

Default the value for each charge as 0

It would help if you could post views of the tables involved

[Aditya_Vinayak]

I didn’t understand. Creating a virtual column for each charge? How would that help?

[Steve]

@Aditya_K1999

I tried the below formula, ignoring the pet size and pet coat attribute for now just to see if I am able to atleast get a sum, but it didnt work.

How didn’t it work? How did you implement this? Please post a screenshot of the configuration.

[Aditya_Vinayak]

Hi Steve

Do you mean the tables?

[Steve]

Sorry, of the computation. The expression you posted looks fine to me, so I’m interested in figuring out why it didn’t meet your needs.

[Jack_Bates]

It would help if you could post views of the tables involved

[Aditya_K1999]

@Steve please see if this help?

[Steve]

Please also post screenshots of the columns for both of the involved tables.

[Aditya_K1999]

Service Details Table:

[Steve]

Hmmm… Seeing nothing wrong. Please post a screenshot of the configuration of the Service Name column of the Services Availed table.

[Aditya_K1999]

Here it is

[AleksiAlkio]

You are trying to compare that Service name is part of your EnumList. The EnumList contains key values as you are using the base of Ref. Because the “Service name” is not the key column, it doesn’t find it from the list. You need to use..

SUM(
SELECT(
Service Details[Service Charge],
IN([Service ID],[_THISROW].[Service Name])))

[Aditya_K1999]

Yes Aleksi, this worked. Understood my mistake. Thank you Steve for the efforts.

[AleksiAlkio]

Good to hear!