Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Column count

Good afternoon First of all, I thank you for your attention. I've been trying to find a solution for a very simple calculation to do with pivot tables, but I can't solve it in PBI. In t...
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi  Syndicate_Admin 

     

    Please try the following measure:

     

     

    Count of Distinct Categories per Customer =

SUMX(
   Values(Table[Customer]),
   CALCULATE(
      DISTINCTCOUNT(Table[Category])
   )
)

     

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi  Syndicate_Admin 

 

Please try the following measure:

 

 

Count of Distinct Categories per Customer =

SUMX(
   Values(Table[Customer]),
   CALCULATE(
      DISTINCTCOUNT(Table[Category])
   )
)

 

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Good morning

    Thank you for yesterday's reply, but now I have another question.

    If on the same exercise you wanted to put a filter on the total units, what would it be like?

    That is, I would like to be able to count the total of categories but only when the total number of units of the same is greater for example to 36 units.

    Thanks in advance.