Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to calculate the representativeness of each brand country-wise and overall division. So I created a measure and used average, but the thing is that I want the card to show me 100% and not 2.1% without clicking any filter. So if I click a particular filter the card changes but without clicking anything it shows me 2.1% instead of 100
So instead of average should I use any other function in the measure?
Solved! Go to Solution.
@yuvanne_11 , You can sue isfiltered to check and have meausre
if(isfiltered(Table[Filter1]), [Card measure],1)
or
if(calculate(isfiltered(Table[Filter1]), allselected()) , [Card measure],1)
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
@yuvanne_11 , You can sue isfiltered to check and have meausre
if(isfiltered(Table[Filter1]), [Card measure],1)
or
if(calculate(isfiltered(Table[Filter1]), allselected()) , [Card measure],1)
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Thank you so much! It worked
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |