Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm having a Matrix that holds values in the rows and in a column weather Yes or No the value was Budgetted.
We are Showing the % of the Row Value. But now I would also display the total amount, so that the user gets an idea that his (ex) 15% non budgetted is 15% of the total value (Bidgetted+Nonbudgetted)
The idea is that When Column is No we just use BLANK() so that there is never a value printed, and on the Yes column we show the sum of Yes and No. I know its a bit a strange way but for now I don't think I can get it visualized otherways.
But my Dax formula doesn't work, this is what happens
Solved! Go to Solution.
Hi @LeboeufHarry
If I understood you correctly you can use the measures :
The pbix is atached
Even a better solution ! KR.
Happy to help 🙂
Hereby the table of sample data and the wanted result for this data.
Type | Reserved | Value |
S0 | Yes | 50 |
S0 | Yes | 10 |
S0 | No | 15 |
S1 | Yes | 100 |
S1 | No | 10 |
S2 | Yes | 200 |
S3 | No | 120 |
Hi @LeboeufHarry
If I understood you correctly you can use the measures :
The pbix is atached
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |