Forum Discussion
Data labels creation issue
- Anonymous1 year ago
Hi, markzuev6
Based on your description, I created the following dataset:
The relationship between them is as follows:
Based on the expression you provided, you want to find the current [Dynamic GRP] as a percentage of the current year (clearing 'Dynamic variables (TopN)' [Player type] and Data [Channel group]).
Create a measure using the following DAX expression:
Measure = ROUND( DIVIDE( [Dynamic GRP], CALCULATE( [Dynamic GRP], ALLSELECTED('Dynamic variables (TopN)'[Player Type]), ALLSELECTED(Data[Channel Group]), VALUES(Data[Year]) ) )*100 , 0 )/100The visual settings are as follows:
If you still have any doubts, you can clarify and clearly describe your expected results in the follow-up along with examples.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, markzuev6
Based on your description, I created the following dataset:
The relationship between them is as follows:
Based on the expression you provided, you want to find the current [Dynamic GRP] as a percentage of the current year (clearing 'Dynamic variables (TopN)' [Player type] and Data [Channel group]).
Create a measure using the following DAX expression:
Measure = ROUND(
DIVIDE(
[Dynamic GRP],
CALCULATE(
[Dynamic GRP],
ALLSELECTED('Dynamic variables (TopN)'[Player Type]),
ALLSELECTED(Data[Channel Group]),
VALUES(Data[Year])
)
)*100 , 0
)/100
The visual settings are as follows:
If you still have any doubts, you can clarify and clearly describe your expected results in the follow-up along with examples.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.