Measures

[yuvanne_11]

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?

[amitchandak · Accepted 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]

Thank you so much! It worked