Forum Discussion

groffia's avatar
groffia
Helper I
8 years ago
Solved

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 ...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 Hi Dale  v-jiascu-msft, what if I want to use the values from that other table and do some calculation like below , its not working as I have written here ... please let me know if you need me to explain my scenario more? 

a =
CALCULATE (
    [Stop Time Per Unit] * values('table1[column2]),
    DimID[Cause Group] IN VALUES ( 'table1'[column] )
)