Forum Discussion

Ynew's avatar
Ynew
Icon for Helper I rankHelper I
8 years ago
Solved

A slicer for a pivot table

Hello All, I need help with coming up with a solution for my problem as below. To make my question easy to understand I define a simple version of my real data. I have three columns as below: Cu...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi Ynew

 

 

How about Adding a calculated column " Customer Type" then using this as a slicer

 

Customer Type =
VAR DistinctCountofProducts =
    CALCULATE (
        DISTINCTCOUNT ( TableName[Products] ),
        ALLEXCEPT ( TableName, TableName[Customer name] )
    )
RETURN
    IF ( DistinctCountofProducts > 1, "Multiple Type", "Single Type" )