Count of distinct values

[Anonymous]

Hi All,

I have a table like below:

Is there a way to achieve this? 

Thank you.

[Parihar1980]

Hello Sir ; I am new to power bi. Kidnly guide me Dax syntax of below calculation.

I wan to Count male and female member in Table under Gender column. Which Kind of Measure I nned to create and the syntax . plz help 

expected resull

table name - Employee

Select   Gender , *  from Employee

Gender             Count

MALE                10

FEMALE             20 

[Parihar1980]

Hello Sir ; I am new to power bi. Kidnly guide me Dax syntax of below calculation.

I wan to Count male and female member in Table under Gender column. Which Kind of Measure I nned to create and the syntax . plz help 

expected resull

table name - Employee

Select   Gender , *  from Employee

Gender             Count

MALE                10

FEMALE             20 

[Anonymous]

Sorry, I made a mistake here. Here is the corrected question.

Thank You!

[Sean · Accepted solution]

Yes create these 2 MEASURES

The Total MEASURE has 2 versions both of which should work

PPC = DISTINCTCOUNT ( 'Table'[Invoice] )

Total PPC = CALCULATE ( [PPC], ALLEXCEPT ('Table','Table'[Sector]) )

Total PPC Alt = CALCULATE ( [PPC], ALL ( 'Table'[Product], 'Table'[Invoice] ) )

[Anonymous]

Dear @Sean,

Thank you very much!

[Anonymous]

Hi All,

I have a table like below:

Is there a way to get this output?

Thank you!

[Baskar]

Use Mtarix Visual. That will help u

[Sean]

Duplicate Post