Forum Discussion

JinDR's avatar
JinDR
Frequent Visitor
8 months ago
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...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    8 months ago

    Please try the measure below:

     

    Card Value =
VAR SelRegion = SELECTEDVALUE(RegionTable[Region])
RETURN
CALCULATE(
    MAX(RegionTable[Value]),
    RegionTable[Region] = COALESCE(SelRegion, "Overall")
)
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
8 months ago

JinDR 

Measure:

Default Card = 
IF(
ISFILTERED(Region),
SELECTEDVALUE(Region[Value]),
CALCULATE(AVERAGE(Region[Value]), Region = "Overall")
)

Card shows 97% default. Slicer filters to region value.

 

If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande