Forum Discussion
DAX Measure ignore filter/slicer selection
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
Super UserHey,
as you can see from this little screenshot
that the measure "All Revenue" is not affected by a slicer selection, here is the DAX for the measure:
All Revenue =
CALCULATE(
SUM(Table1[Amount])
,'Table1'[Category] = "Revenue"
,ALL('Table1'[City])
)I'm wondering if there are more slicer / filter involved in your table that may affect the calculation.
Regards
Tom
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
v-yulgu-msftMicrosoft Employee
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
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
HI there,
Can you let me know how I would write the formula where, if instead of calculating the total Revenue, I wanted my measure to always be the total of only 1 city.
For example, If you have Hamburg selected as shown, but I want Toronto Revenue to be my "All Revenue" measure....my table on the right would show "Hamburg, Revenue, 100, 75"
Is this possible?
i am having meaures column in %
ID Value
A 10
b 20 so slicer should show two categories A
c 30 B
d 40
e 50
f 60
if(value >30 ,value<50,"A","B")
But i am getting only one value in slicer ,how to achieve two values in slier
