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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
TMLewis
Frequent Visitor

Simple table, simple problem, tough solve. Is this possible in PowerBI?

Hello, this simple problem has been plaguing me for over a week.  I don't want the promotions to differ depending on the slicer selection.  Is this possible in Power BI? 

 

https://imgur.com/OrsNuwh  (with missing Promotions in list)

https://imgur.com/JRxIc2k     (correctly display the Promotions in list)

 

More detail:

 

So I have only 1 file which I import into PowerBI. No data modeling challenges here.

 

My dashboard consists of 2 measures, and 3 attributes. 

 

Selected Forecast Sales:

Selected Forecast Sales = SUM('Table'[Forecast Sales])

and my problem child, which we'll get to soon:  Current Forecast Sales:

Current Forecast Sales = CALCULATE(SUM('Table'[Forecast Sales]), Quarter = "Current Version")

 

The three attributes, are as follows:

 

- Category

      -Subcategory

          -Promotion Group 1

                -Promotion Group 2

                -Promotion Group 3

 

 

Main problem:  Is there a way in DAX that I can force the Promotions to stay visible in the table, so the user can view all promotions that are contributing to the row total for its parent Subcategory?  

 

Thanks! 

 

 

 

1 REPLY 1
Anonymous
Not applicable

To display members with all measure values = BLANK, check the settings of the visual. You'll find a setting that will let you show all members of a dimension regardless of measures' values.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.