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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , if Gender is category value. then it should pass using drill through. But it is measure like 2 measures male and female then it will not pass using drill through

  • 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