Forum Discussion
Solved
Non Additive Hierarchy Slicer
Hi, I want to create Non Additive Heirarchy Slicer.When user select Americas in Hierarchy slicer, then All value which is 200 should display in graph instead of Total 470. Dataset ...
Hi atul9063
You may create a measure like below:
Measure = IF ( HASONEVALUE ( Table3[Country] ), SUM ( Table3[Value] ), CALCULATE ( SUM ( Table3[Value] ), Table3[Country] = "ALL" ) )Regards,
Cherie
Hi atul9063
You may create a measure like below:
Measure =
IF (
HASONEVALUE ( Table3[Country] ),
SUM ( Table3[Value] ),
CALCULATE ( SUM ( Table3[Value] ), Table3[Country] = "ALL" )
)
Regards,
Cherie
I have added two heirarchy slicer Client and UserType.As per above solution, its working fine for ClientType but not for UserType.For UserType is adding up values.Could you please check below DAX and let me know what i m doing wrong?
ClientMeasure =
IF (
HASONEVALUE ( r1Metrics[ClientType] ) || HASONEVALUE ( r1Metrics[UserType] ) ,
SUM ( r1Metrics[Measure] ),
CALCULATE ( SUM ( r1Metrics[Measure] ), r1Metrics[ClientType] = "ALL", r1Metrics[UserType]="All" )
)