Filter based on count of legendsbhaving values

[Anonymous]

if there there are 2 legends and for one value only one legent have value then i dont want to show that legend. means if both legends have value then only bar should be shown (Source is SSAS)

[technolog · Accepted solution]

Create these measures in your SSAS model and use the third one in the visual.

Legends with data count

COUNTROWS(
FILTER(
ALLSELECTED( 'Legend'[Legend] ),
NOT ISBLANK( CALCULATE( [Amount] ) )
)
)

Legends required count

COUNTROWS( ALLSELECTED( 'Legend'[Legend] ) )

Amount only when all legends present

IF(
[Legends with data count] = [Legends required count],
[Amount],
BLANK()
)

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490