Forum Discussion

Pegasus's avatar
Pegasus
New Member
3 years ago

Multiple responsive filters

Hello, We all know we can use visuals as a filter example if we have a bar chart of a number of students according to gender, I will have different bars. If we select one bar out of it, All visuals ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Pegasus , Create a numeric patameter

 

Then have measure like Assume you have % meausre

calculate([Percent], filter(Values(Table[Student]), [Percent] > [Param]/100) )

 

or

 

if(isfiltered(Table[Student]),  Sumx( filter(Values(Table[Student]), [Percent] > [Param]/100), [Perent] ) , [Percent] )

 

https://docs.microsoft.com/en-us/power-bi/desktop-what-if