Forum Discussion

LuciaS1's avatar
LuciaS1
Regular Visitor
3 years ago
Solved

Distinct count by groups

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 distin...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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] ) ) )