'Power BI DAX:Matrix with division of two columns where data summarized by category
I want to get a % of two columns in Power BI matrix.
So I want to divide Total CCI Amount / Total Revenue and multiply by 100%. I want to have a new column in the matrix that does this calculation called CCI %.
It seems simple, but I am having trouble despite searching and trying a lot. I am very beginner in PowerBI.
Can anyone help with this?
I think the issue is in how my dataset is designed, but I cannot change it as this is just a sample from actual report that comes in this format
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|