If functions on cards

[Anonymous]

ISSUE: When I choose all as a Filter, Portfolio Name and OCM Owner shows value that is FIRST to both fields. The FIRSTS of each data isn't the right relationship. 

QUESTION: Is there a way that if the filter is ALL, the Portfolio Name and OCM Owner cards would both show DASH (-) or null. There's no issue if I select a specific Portfolio Name because both cards show the correct values. 

[d_gosbell]

You might also be able to use a measure with the SELECTEDVALUE function which has an optional parameter for what to return when there are multiple values selected.

eg.

Portfolio Name (Card) = SELECTEDVALUE(  'tablename'[Portfolio Name] , "-")

[V-pazhen-msft · Accepted solution]

@Anonymous 

Measure1 = IF(ISFILTERED(Sheet1[Portfolio Name]),[Portfolio Name],"-")

Measure2 = IF(ISFILTERED(Sheet1[Portfolio Name]),[OCM Owner],"-")

Best Regards

Paul Zheng

[itsmebvk]

@Anonymous  Create a measure with follwing expression and see if that helps you.

Value =

var Distinct_Count = DISTINCTCOUNT(BaseData[Color])

var Count_All = CALCULATE(DISTINCTCOUNT(BaseData[Color]),ALL(BaseData[Color]))

return IF(Distinct_Count=Count_All,"-----",SUM(BaseData[SalePrice]))

Click 👍 if your issue is resloved.

[Greg_Deckler]

Perhaps try something like:

IF(HASONEVALUE('Table'[Column]),< whatever your value is >, BLANK())