Forum Discussion
Solved
Dax multiple conditional sum
Hi guys, I have a table which looks like this: Store Phases Estimated cost J&J A 1 J&J B J&J C 2 J&J D 3 TimLee A 5 TimLee B 3 TimLee C TimLee D ...
- Yes, a MEASURE does not have the row context of the table. You can try two options:
Option A:
Use SUMX(Table, IF( insert your formula here)
Option B:
Use the SELECTEDVALUE function around any column you want to reference. This will only return a value if there is 1 value for the selected column, so requires a specific table configuration.
I prefer Option A in this case.
Not totally sure on what you are looking for but you can make a table visual with your Store column and this measure. It will show 1 if the B value for that store is blank (and 2 if not).
B Blank = IF(ISBLANK(CALCULATE(MIN(Table[Estimated Cost]), Table[Phases] = "B")), 1, 2)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat