Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I just come up with something I need your input on, I am not sure if there is something like Excel in Power BI.
This is done in Excel,
In the screenshot below. The sum of Row 2, Column1 is 3.57% of the total of Column1($280).
Then sum of Rows 2 & 3 of Column1 is 10.71% of the total of Column1($280).
Then sum of Rows 2, 3, & 3 of Column1 is 21.43% of the total of Column1($280).
It keep adding rows one by one until it reach the total amount and 100%.
Thank you,
Mohammad
Hi,
What's important to know is the order in which the numbers should appear to calculate the running total. Should the amounts be arranged in ascending order or should they be arranged in ascending/descending order of some other field (such as date, Product). If you need further help, then share the download link of the PBI file with your Table/matrix visual already built.
@Mohammadwazeri You basically need a running total but for that you need something to define "earlier".
@Mohammadwazeri, This can be achieved with DAX Measure. Please refer the below URL
https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |