Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi , i have Group Customer Name , Means some customer has 10 Outlets , and some has only 1 ,
and i would like to create a condition , with Tottal Target NSR , i am using metric visualization
i am using below measure , but it seems not work , even i change to Column , it's also not right. the result turns out wrong dramatically.
@Chanleakna123
Can you try this measure:
Tier. =
VAR _TGT = SELECTEDVALUE = 'Target Weekly Stability'[Total Target Weekly] RETURN
IF (
_TGT >= 70000, "T1",
IF (
_TGT>= 16000,
"T2",
IF ( _TGT >= 3000, "T3" )
)
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Chanleakna123 ,
Measure cannot be added to matrix visual as row.
The calculated column cannot contain measure, which will result in incorrect calculation.
The calculated column is calculated statically while the measure is calculated dynamically.DAX measure are based on row context so any given value from slicers, filters, interactions with other visualizations, variables, relationships and so on can influence your result.
Maybe you could consider changing [total target weekly] to a calculated column, and then creating a calculated column based on [total target weekly] to add it to row of matrix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |