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

8 years ago

Hi Ynew

It seems your version of Excel does not support DAX variables

Please try this instead

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

Zubair_Muhammad
8 years ago
HI Ynew

Some good articles on DAX variables

https://www.sqlbi.com/articles/variables-in-dax/

https://msdn.microsoft.com/en-us/library/mt243785.aspx

Zubair_Muhammad

Community Champion

8 years ago

Hi Ynew

It seems your version of Excel does not support DAX variables

Please try this instead

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

Ynew

Helper I

8 years ago

Hi Zubair_Muhammad

Thank you very very much for your help. It is working now. And sorry, I did not know that there is a link between Excel and Power BI. Good to know that too, I will dig into that to learn how I can use.

Many thanks again.

Forum Discussion

A slicer for a pivot table