Forum Discussion
If functions on cards
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.
4 Replies
- Greg_Deckler
Community Champion
Perhaps try something like:
IF(HASONEVALUE('Table'[Column]),< whatever your value is >, BLANK())
itsmebvkContinued Contributor
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.- d_gosbell
Super User
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] , "-")
