Forum Discussion

Venkatz's avatar
Venkatz
New Member
3 years ago
Solved

Using Calculate and Filter in measure

Hi. I am new to PowerBI. I have extracted data from excel. I have a column called Gender which contains data as Male ,  Female, Not specified. I have added a card to my dashboard and trying to get...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    Venkatz ,

     

    try this

    Measure 2 = CALCULATE(COUNT('Table 1 (Sheet1)'[Gender]),FILTER('Table 1 (Sheet1)','Table 1 (Sheet1)'[Gender]="Male"))

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin
    Vote For my Idea💡

     

Venkatz's avatar
Venkatz
New Member
3 years ago

Hi.

Please find the below

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    Venkatz ,

     

    try this

    Measure 2 = CALCULATE(COUNT('Table 1 (Sheet1)'[Gender]),FILTER('Table 1 (Sheet1)','Table 1 (Sheet1)'[Gender]="Male"))

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin
    Vote For my Idea💡

     

    • Venkatz's avatar
      Venkatz
      New Member
      3 years ago

      Thank you..

      That worked