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💡

     

Idrissshatila's avatar
Idrissshatila
Super User
3 years ago

Hello Venkatz ,

 

try this 

Measure 2 = CALCULATE(COUNT('Table 1 (Sheet1)'[Gender]),FILTER('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.

Thanks.  Apologies. Tried it and now getting error as Parameter is not the correct type.

 

Measure 2 = CALCULATE(COUNT('Table 1 (Sheet1)'[Gender]),FILTER('Table 1 (Sheet1)'[Gender]="Male"))
    • 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💡