Field parameter in combination with slicer always returns 100%

[PowerRon]

Hi,

see the pbix in the link

https://www.dropbox.com/scl/fi/aqlehbivdtss4ipuj3h5o/test.pbix?rlkey=8cckq6keka9vjdlyal9mng68h&dl=0 

There is a slicer nominal-percentage.
Why is the percentage working in the upper stacked colunm chart which just uses a measure (Sum Quantity), but not in the lower one where I use a field parameter?
How can I make the lower one working as well?

Hope someone can help

Regards
Ron

[PowerRon]

Thnx @parry2k you saved me 🙂

[parry2k · Accepted solution]

@PowerRon you cannot apply  filters on the variables and that's why numbers are going 100%, you need to change it to this:

Sum Parameter (Label) =
VAR _selection1 =
    SELECTEDVALUE ( 'Slicer Table'[ID] )
VAR _selection2 =
    IF (
        SELECTEDVALUE ( 'Parm_Measures'[Measure Name] ) = "Sum Price",
        [Sum Price],
        [Sum Quantity]
    )
VAR _result =
    SWITCH (
        _selection1,
        1, FORMAT ( _selection2, "#,0" ),
        FORMAT (
            DIVIDE (
                _selection2,
                CALCULATE (
                    IF (
                        SELECTEDVALUE ( 'Parm_Measures'[Measure Name] ) = "Sum Price",
                        [Sum Price],
                        [Sum Quantity]
                    ),
                    ALLSELECTED ( Sales[Channel] )
                )
            ),
            "0%"
        )
    )
RETURN
    _result