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 using the count measure, and it functions well. However, I am having trouble utilising many variable in the same measure there the data is not filter in drill through.

 

Please help me on the above request thanks in advance!

 

Regards,

Srinath

Arulprakash_C 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super 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
        Super 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() ))