Forum Discussion
Conditional formatting when the measure used for formatting contains WEEKNUM
Hello, I have an issue with conditional formatting when using two measures. I want to format the values of my table (where the coloumns are the last 10 weeks) by using the value of a measure. ...
Anonymous
I messed with it a bit and your format measure should work. I did do a different Avg 10w measure:
Avg 10w. claims = VAR _EOPW = CALCULATE ( MAX ( Dim_date[Date] ), Dim_date[WeekNo] < WEEKNUM ( TODAY (), 2 ) ) RETURN CALCULATE ( AVERAGEX ( VALUES ( Dim_date[WeekNo] ), [ClaimCount] ), DATESBETWEEN ( Dim_date[Date], _EOPW - 69, _EOPW ) )Take a look at my attached sample, see if that helps. I used your color measure as is to format my ClaimCount field:
The calculated value is a little higher than the real value.
jdbuchanan71
Super User
Super UserYou will need to share your .pbix, it works in my testing file so not sure what the problem is.