Forum Discussion
Table and Card not Matching
Hi i have a page filter by a name. On the page I have table with the below.
Table: Info
| Name | Diversity | Sponsorship | AWA/RLE |
| a | underrepresented | YES | None |
When I put the column in a card it just gave the option of first, last, distinct, count. So I created the below measure
Diversity = IF(
SELECTEDVALUE(America[Underrepresented/ represented])="Underrepresented",
"Underrepresented",
IF(
SELECTEDVALUE(America[Underrepresented/ represented])= "Represented",
"Represented",
"Not Known"))
However when I put it in a card I get Not Known, but the table shows as Underrepresented. I just want a card that will what the correct diversity is as on the table.
| Underrepresented |
1 Reply
SELECTEDVALUE() has no meaning in that context, so it won't evaluate to True.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
