SELECTEDVALUE Using Question

[Lily36876]

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

Threshold = IF(SELECTEDVALUE('Brand Review Threshold'[Review Threshold])=BLANK(),"",IF(OR('Date'[SalesTargetAchv%]<1-

SELECTEDVALUE('Brand Review Threshold'[Review Threshold]),SELECTEDVALUE('Brand Review Threshold'[Review Threshold])>1+

SELECTEDVALUE('Brand Review Threshold'[Review Threshold])),"Review",""))

Is it not feasible to useSELECTEDVALUE?

[amitchandak]

@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",""))

[Lily36876]

Hello!!

Thanks for reply,

but I think it should be a measure?

because I can't create this column in connect table.