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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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