Forum Discussion
Solved
Default value on card if data on one table
For simplified purposes, I have a table like this: Region Value AMERICAS 90% ASIA 85% EUROPE 95% Overall 97% Is it possible to write a measure (for a card vi...
Please try the measure below:
Card Value = VAR SelRegion = SELECTEDVALUE(RegionTable[Region]) RETURN CALCULATE( MAX(RegionTable[Value]), RegionTable[Region] = COALESCE(SelRegion, "Overall") )
cengizhanarslan
Super User
Super UserPlease try the measure below:
Card Value =
VAR SelRegion = SELECTEDVALUE(RegionTable[Region])
RETURN
CALCULATE(
MAX(RegionTable[Value]),
RegionTable[Region] = COALESCE(SelRegion, "Overall")
)Worked great, was just what I needed. Thank you!!
