Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
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.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
100 | |
64 | |
44 | |
37 | |
35 |