Forum Discussion

Marcuskw's avatar
Marcuskw
New Member
8 years ago
Solved

DAX Measure ignore filter/slicer selection

Hi,   I'm interested in creating a measure that doesn't change with Filter/Slicer settings to be included as a benchmark. I've tried writing:   Revenue = CALCULATE(SUM(Table[Amount]);Table[Categ...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Marcuskw,

     

    Is there a way to have the second table show all citys even if you clicked "Hamburg"? 

    No. Since the slicer is related to table visual, it is not possible to still show all rows when you have selected an item in slicer. Unless you disable the interaction between slicer and visual, as mentioned by TomMartens.

     

    To workaround your requirement, you could create an unrelated table which lists all available city names. That case, when you choose any value from slicer, the table visual won't be filtered by it. You said some other measures should still be affected by slicer selection, you could add filters into these measures. For example:

     

    Selected city =
SELECTEDVALUE ( Table[Category] )



Measure =
CALCULATE (
    SUM ( Table[value] ),
    FILTER ( Table, Table[City] = [selected city] )
)

     

    Regards,

    Yuliana Gu

     
Marcuskw's avatar
Marcuskw
New Member
8 years ago

Hi TomMartens,

My aim is to have multiple measures in the same table where one interacts with the filter value and one doesn't.

I see that you edited the second table to not interact with the filter selection(Edit interactions and "None")

 

Is there a way to have the second table show all citys even if you clicked "Hamburg"?

 

Thanks

Marcus

Rendani_motlopi's avatar
Rendani_motlopi
New Member
3 years ago

 

No. Since the slicer is related to table visual, it is not possible to still show all rows when you have selected an item in slicer. Unless you disable the interaction between slicer and visual, as mentioned by TomMartens.

 

To workaround your requirement, you could create an unrelated table which lists all available city names. That case, when you choose any value from slicer, the table visual won't be filtered by it. You said some other measures should still be affected by slicer selection, you could add filters into these measures. For example:

 

Selected city =
SELECTEDVALUE ( Table[Category] )



Measure =
CALCULATE (
    SUM ( Table[value] ),
    FILTER ( Table, Table[City] = [selected city] )
)

 

Regards

rendani motlopi