Forum Discussion

MP87's avatar
MP87
New Member
2 years ago
Solved

Help with Counting

I have data that identifies internal part numbers, along with manufacturer names and part numbers. I am trying to provide information on how many, and what, items have a certain number of parts liste...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi MP87 

    If I understood you correctly, you can add a calculated column that will count the manufacturers for every part.
    The formula that you can use for this :

    count manufacturers for part = CALCULATE(DISTINCTCOUNT('Table'[Manufacturer]), ALLEXCEPT('Table','Table'[Internal Part Number]))

    and use this column as a slicer :

    the pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi MP87 

If I understood you correctly, you can add a calculated column that will count the manufacturers for every part.
The formula that you can use for this :

count manufacturers for part = CALCULATE(DISTINCTCOUNT('Table'[Manufacturer]), ALLEXCEPT('Table','Table'[Internal Part Number]))

and use this column as a slicer :

the pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly