Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issue with count measure using multiple variables.

Hello Community, I created a visual where we can select the gender and see how many people are male or female. We may drill through the page by clicking on the gender. I verified the data there us...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

amitchandak Thanks for your reply,
But in this case i am using 2 measures first one is count measure which works fine in drill through another one is variable measure which is used to get percentage%


amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , Is you % measure is like

 

divide(count(Table[Column]), calculate(count(Table[Column]), removefilters(Table[Gender]) ))

 

or

 

divide(count(Table[Column]), calculate(count(Table[Column]), allselected(Table[Gender]) ))

 

 

or

 

divide(count(Table[Column]), calculate(count(Table[Column]), allselected() ))

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi amitchandak 
    VAR 1 = CALCULATE(COUNT(column 1) , ALL(Table[Gender]))
    VAR 2 = CALCULATE(COUNT(column 1) , condition[column 2 ] = 1)
    VAR 3 = DIVIDE(VAR 2,VAR 1)
    RETURN
    VAR 3