dax card
1 TopicSELECTEDVALUE with the new Card Category field not responding as expected
I'm getting weird results with a DAX calculation I'm using for conditional formatting of the new card type and having trouble finding a relevant answer. My data is in two tables: Metric (a dimension table) MetricID MetricName 1 All Issues 2 High Severity Issues MetricFact (my fact table) MetricID MeasureDate MeasureValue 1 1/1/26 10 1 2/1/26 20 1 3/1/26 30 2 1/1/26 2 2 2/1/26 4 2 3/1/26 2 The two are connected by the MetricID field and on the Metric table I've added a piece of DAX that dynamically determines the color: WhatColor = VAR SV = SELECTEDVALUE(Metric[MetricName]) RETURN SWITCH(SV, "All Issues","blue", "High Severity Issues","red", "yellow") The problem is, this works great with a matrix visual, but if I try to use it to conditionally format the cards, it always turns them yellow implying a single value for SELECTEDVALUE() is not available. How do I get the category for each card successfully to determine the color if SELECTEDVALUE() doesn't return it?Solved1.2KViews0likes9Comments
