Solved: Distinct count by groups

LuciaS1 · ‎04-10-2023

HI!

I need to count distinct count by groups. I tried this measue but I am not sure if it it right

COUNTX(DISTINCT(Data_2022), Data_2022[Tovar])

in group unique i need to count only distinct values of "tovary" so in thic pisture result will be 11

Is this measure right ? or is there some other way to count distinct values of groups

Thank you !

Jihwan_Kim · ‎04-10-2023

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

expected result measure: =
SUMX ( VALUES ( Data[Unique] ), CALCULATE ( DISTINCTCOUNT ( Data[Tovar] ) ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

View solution in original post

LuciaS1 · ‎04-10-2023

@Jihwan_Kim Thank you !

Jihwan_Kim · ‎04-10-2023

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

expected result measure: =
SUMX ( VALUES ( Data[Unique] ), CALCULATE ( DISTINCTCOUNT ( Data[Tovar] ) ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page