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

[Anonymous]

Hi All

I have this % distribution I want to calculate.

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

[Anonymous]

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

[V-lianl-msft]

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-... 

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]

@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]))

[Anonymous]

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