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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Anonymous
Not applicable

How to create a measure that only shows values based on if a fact table field has any values.

Hi All

I have this % distribution I want to calculate.

 

dalex3333_1-1618558493453.png

The purple color is the raw quantity numbers,
the black bars are the market share.
The Red quanities is using this formula 

Quantity measure = IF(MIN('External Market Share'[Units]) = 0, 0,SUM('Combined Cube'[Quantity Actual]))

But this will not help me in my table to the left when calculating the Marketshare

How can this be done?
Kind regards
Daniel

 

4 REPLIES 4
Anonymous
Not applicable

Sorry that I ask again.
I am really just trying to include figures from a specific fact table based on if there are values in another fact tables, they are related by the date dimension.
Unsure if there are any tips

Hi @Anonymous ,

 

Be aware that DAX measure are based on row context.

It is very difficult to analyze without looking at the data and just by imagining. See if you can share the sample pbix with dummy data.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User
Super User

@Anonymous , Not very clear, making blank can remove it from visual

 

Quantity measure = IF(MIN('External Market Share'[Units]) = 0, blank(),SUM('Combined Cube'[Quantity Actual]))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Sorry I am unclear. 

I know how to remove it from the visual on the right side.

But in the table, there is no min =0

How do I ensure that the last month, where there is no marketshare data yet (blank) is excluded from the table calculation 

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors