Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filtering Table Based On Measure Value

Hello,   I'm running into some issues while trying to parameterize a query in Power BI Report Builder. For the parameters, I need to be able to select multiple values so I can't use conventional fi...
DAX Query
Help required
Power BI report builder
  • Anonymous's avatar
    Anonymous
    6 years ago

    I looped back to a result which worked with single values ( FILTER( __DS0Core,'Meta_EngStatusSummary'[WorstStatus2] =@ProjStatus) ) and realized I was over-thinking this... This is the EVALUATE statement which ended up working for me:

    FILTER( __DS0Core,'Meta_EngStatusSummary'[WorstStatus2] IN GetKeyStatusColumn)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I looped back to a result which worked with single values ( FILTER( __DS0Core,'Meta_EngStatusSummary'[WorstStatus2] =@ProjStatus) ) and realized I was over-thinking this... This is the EVALUATE statement which ended up working for me:

FILTER( __DS0Core,'Meta_EngStatusSummary'[WorstStatus2] IN GetKeyStatusColumn)

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks a lot, I had similar problem and your approach gave me the solution:

Measures:

    Current Week = WEEKNUM(TODAY() , 21 )

   

Total Planned Week WO =
    CALCULATE ( COUNT ( 'WO'[WO Number] ),
    WO[WO Status] IN { "MH", "MJ", "MK" },
    FILTER( WO,
                 WO[Planned Week] IN { [Current Week] } ) )