Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
73 | |
42 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |