Forum Discussion
groffia
8 years agoHelper I
Filter for multiple values using a measure _ DAX Expression Help
I'm having a hard time figuring out what is wrong with my calculation other than its hideousness... MEASURE: Stop Time Per Unit:=[Total Stop Time]/[Total Machines] Now I need to add up all ...
- 8 years ago
Hi groffia,
If you have to list the values explicitly, you can try it out like this:
STPU Overall:= CALCULATE ( [Stop Time Per Unit], DimID[Cause Group] IN { BLANK (), "Unknown", "Supply Chain", "Design", "Engineering", "etc" } )If the measure can read the values from a column, you can try it like this:
a = CALCULATE ( [Stop Time Per Unit], DimID[Cause Group] IN VALUES ( 'table1'[column] ) )Note: table1 could be created by formula or by hand.
Best Regards,
Dale
groffia
8 years agoHelper I
Yes, I realize it is a redundancy... but unfortunately necessary.