Forum Discussion
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...
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💡
Hi.
Please find the below
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💡
Thank you..
That worked