Forum Discussion
Multiple filters in 1 visual
RemkoS , In this I think measure filter will be better
Like
calculate([Antel Wensen], filter(Table, Table[Stats] IN (3,4,5))) //Measure for Table 1
calculate([Antel Wensen], filter(Table, Table[Stats] IN (1,2))) //Measure for Table 2
Now to get the over all values
calculate([Antel Wensen], filter(allselected(Table), Table[Stats] IN (3,4,5))) // overall with all selected
calculate([Antel Wensen], filter(all(Table), Table[Stats] IN (3,4,5))) // ignore all flter
Now the last one can be used every if use set of visual by separated by slicer using interactions
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thanks Amitchandak! But for some reaso I cannot select all colums in my measure.
I can only select other measures.
This is probably a beginners mistake or misunderstanding but it limits me at this time.
Can you explain why I cannot select values other than measures?