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.
Thanks for the quick reply.
Yes I've done that and can display the icons as images in tables or some other visualisations, but I want to be able to only show image associated with the lowest severity (and only the lowest), at a given Slicer level.
Community ChampionYou 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?
- Greg_Deckler
Yep, good catch!