Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
I have encountered a problem. Each of my brands has a Review Threshold.
If the performance achievement rate of a brand exceeds this Review Threshold, a review needs to be shown.
However, with the current formula I'm using and after adding fields into a matrix, I'm facing this issue.
Each brand is displaying Review Thresholds that do not belong to them.
My dax using below
Is it not feasible to useSELECTEDVALUE?
@Lily36876 , if Review Threshold is a measure then selectedvalue or max is not needed. Try with max if this is a column
IF(Max('Brand Review Threshold'[Review Threshold])=BLANK(),"",IF(OR('Date'[SalesTargetAchv%]<1-
Max('Brand Review Threshold'[Review Threshold]),Max('Brand Review Threshold'[Review Threshold])>1+
Max('Brand Review Threshold'[Review Threshold])),"Review",""))
Hello!!
Thanks for reply,
but I think it should be a measure?
because I can't create this column in connect table.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |