Forum Discussion
Dynamic Image Display
You could probably do something along the lines of create a measure like:
Lowest = CALCULATE(MIN([Severity]),ALLEXCEPT(Table,Table[Category]))
Then create another measure like:
IsLowest = IF(SUM([Severity])=[Lowest],1,0)
Then drop your IsLowest as a filter on your table visualization of the error code images.
The idea here is that Lowest calculates to the MIN taking into account the Category. The IsLowest will be filtered by the row context of the table so only the lowest will be 1.
You could probably do something along the lines of create a measure like:
Lowest = CALCULATE(MIN([Severity]),ALLEXCEPT(Table,Table[Category]))
Then create another measure like:
IsLowest = IF(SUM([Severity])=[Lowest],1,0)
Then drop your IsLowest as a filter on your table visualization of the error code images.
The idea here is that Lowest calculates to the MIN taking into account the Category. The IsLowest will be filtered by the row context of the table so only the lowest will be 1.
This does the job. Nice thinking around the issue.
I was hoping not to use a Table to do the visualisation but it'll work.
Small Edit:
Am I right that
IsLowest = IF(SUM([Severity])=[Lowest],1,0)
Should read
IsLowest = IF(MIN([Severity])=[Lowest],1,0)
as I want to look for the Minimum value in [Severity] for my comparison?
Yep, good catch!