Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filtering a Demension Filter

Hi Experts   I have a filter in the following format in a table in Power BI Name     Index AOP       1 PY          2   i issues i am having is that when a user does not select either AOP and o...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Drag measure below to Visual level filters and set Show items when the value is not blank.

    Measure =
CALCULATE ( SELECTEDVALUE ( Table1[Name] ), ALLSELECTED ( Table1[Name] ) )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous,

 

Drag measure below to Visual level filters and set Show items when the value is not blank.

Measure =
CALCULATE ( SELECTEDVALUE ( Table1[Name] ), ALLSELECTED ( Table1[Name] ) )