Data Labels Calculation Issues

[markzuev6]

Hello,

I am trying to create data labels showing %, while the chart should show absolute numbers.

My current formula works well if I switch the X and Y axis dimensions, but the calculation goes wrong in the current set up. Please advise how the formula should look like. 

Here is my chart example:

My current formula:

Yearly player group SOV label =

ROUND(

    DIVIDE(

        [Dynamic GRP],

        CALCULATE(

            [Dynamic GRP],

            ALLSELECTED('Dynamic variables (TopN)'[Player type]),

            ALLSELECTED(Data[Channel group]),

            VALUES(Data[Year])

        )

    ) * 100, 0

) & "%"

Thank you

[Kedar_Pande]

Can you try:

Yearly player group SOV label =
VAR TotalGRP = CALCULATE(
[Dynamic GRP],
ALLSELECTED(Data[Channel group]),
VALUES(Data[Year])
)
RETURN
IF(
TotalGRP > 0,
ROUND(DIVIDE([Dynamic GRP], TotalGRP) * 100, 0) & "%",
"0%"
)

[markzuev6]

It gives the same result as mine, so not really correct, but thank you

[Anonymous]

Hi All，
Firslty  Kedar_Pande thank you for your solution!
And @markzuev6 ,Hello, in order to better help you with this issue, would it be convenient for you to provide some sample data or PBIX files? This way I can directly see exactly what MEASURE does and provide more specific advice. Thank you for your understanding and cooperation!
If you are not sure how to upload a pbix file, you can refer to the link below, looking forward to your reply!

How to Get Your Question Answered Quickly - Microsoft Fabric Community

[markzuev6]

Underlying data for the chart can be seen here GRP DYNAMICS BY GROUPS.xlsx