Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Gone measure results after Matrix value selected

  Data model   SalesAmountWithTotal = VAR _CurrentAxis = SELECTEDVALUE('DimChannelTotal'[ChannelName]) RETURN IF(_CurrentAxis = "Total"; IF(SELECTEDVALUE(YesNo[Values];1) = "Yes"; SUM(FactSa...
Need Help
Show and Tell
Tips and Tricks
Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

Nope. this is not working, as DimChannel[ChannelName]  never = "Total"

As Total is custom created field, so if i do like your example i loosing Total line in chart

 

DimChannelTotal =

FILTER (
DISTINCT (
UNION (
DISTINCT ( DimChannel[ChannelName] ),
ROW ( "Selected", "Selected" ),
ROW ( "Total", "Total" )
)
),
NOT ISBLANK ( [ChannelName] )
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Analitika ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. I created a column chart as a custom legend... And for SELECTEDVALUE( ) return the value which the field filtered, it will return no data if there is no data selected...

You can also refer the below video to get it.

Want a custom LEGEND for your Power BI visual? WATCH THIS!

Best Regards