topic Re: Filter based on count of legendsbhaving values in DAX Commands and Tips

Filter based on count of legendsbhaving values

Anonymous — Tue, 31 Mar 2020 06:38:57 GMT

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)

Re: Filter based on count of legendsbhaving values

Anonymous — Tue, 31 Mar 2020 07:13:46 GMT

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

Re: Filter based on count of legendsbhaving values

technolog — Sun, 12 Oct 2025 13:21:04 GMT

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()
)