Forum Discussion
Solved
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 1...
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
