Gone measure results after Matrix value selected

[Analitika]

Data model

Data model

SalesAmountWithTotal = VAR _CurrentAxis = SELECTEDVALUE('DimChannelTotal'[ChannelName]) RETURN IF(_CurrentAxis = "Total"; IF(SELECTEDVALUE(YesNo[Values];1) = "Yes"; SUM(FactSales[SalesAmount]); BLANK() ); CALCULATE( SUM(FactSales[SalesAmount]); DimChannel[ChannelName] = _CurrentAxis ) )

And Matrix

DimChannel[ChannelName] | DimChannel[ChannelLabel] | FactSales[DataKey]

Problem is that ChannelName working good only if i press in matrix on DimChannel[ChannelName], if in matrix i press on column value only Total left and i cant see ChannelName anymore. So how to show always ChannelName not matter which column value selected?

and why if i put in separate measure _CurrentAxis = SELECTEDVALUE('DimChannelTotal'[ChannelName])

it always showing empty values but working in SalesAmountWithTotal measure?

[v-yiruan-msft]

Hi @Analitika ,

As checked your post description, the line chart using the field DimChannel[ChannelName] not the field 'DimChannelTotal'[ChannelName], so please update the formula of your measure [SalesAmountWithTotal] as below and check whether you can get the correct result:

SalesAmountWithTotal =
VAR _CurrentAxis = DimChannel[ChannelName]
RETURN
    IF (
        _CurrentAxis = "Total",
        IF (
            SELECTEDVALUE ( YesNo[Values], 1 ) = "Yes",
            SUM ( FactSales[SalesAmount] ),
            BLANK ()
        ),
        CALCULATE (
            SUM ( FactSales[SalesAmount] ),
            DimChannel[ChannelName] = _CurrentAxis
        )
    )

Best Regards

[Analitika]

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] )

)

[v-yiruan-msft · Accepted solution]

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