Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Filter based on count of legendsbhaving values

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)

 

 
 
 
 
2 REPLIES 2
technolog
Super User
Super User

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
Not applicable

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.