Forum Discussion

Helper 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

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