Forum Discussion
Measures
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?
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/
2 Replies
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
