Forum Discussion
Helper IA slicer for a pivot table
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" )
Helper IHi Muhammad,
Yes I tried, but the tool does not understand the first and last part of your formulation. The highlited parts I mean.
I checked your image, I assume you have formulated in Excel. Even in Excel I could not get the same formulation. Could you please send me the exact formulation you have in power BI?
Community ChampionHi 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
- Ynew
Thank you very much. I will surely check them since I need to be expert in power BI. I will use it alot for analyzing my data.
- Zubair_Muhammad
Hi Ynew
Books are one of the best ways to build your foundation in Power BI
Consider buying all of these
- Building Data Models With Power Pivot
Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
- Definitive Guide to DAX
- Ynew
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.