The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hey,
I would like to kindly ask for help on writing a measure that will add line by line a variable called “%”
I have a table in Power BI:
And I need a table with the measure “Total sum” as below:
My problem is to calculate the cumulative sum for values that are the same, maybe it is possible to add the ranking per row, where for 17% will be 1 and 2?
Thank you in advance for your help!
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
One of ways to achieve this is using WINDOW dax function and try order the sequence by percent value descending and by type number ascending at the same time.
WINDOW function (DAX) - DAX | Microsoft Learn
expected result measure: =
CALCULATE (
[percent %],
WINDOW (
1,
ABS,
0,
REL,
ALL ( data[type] ),
ORDERBY ( [percent %], DESC, data[type], ASC )
)
)
Hi,
Please check the below picture and the attached pbix file.
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
One of ways to achieve this is using WINDOW dax function and try order the sequence by percent value descending and by type number ascending at the same time.
WINDOW function (DAX) - DAX | Microsoft Learn
expected result measure: =
CALCULATE (
[percent %],
WINDOW (
1,
ABS,
0,
REL,
ALL ( data[type] ),
ORDERBY ( [percent %], DESC, data[type], ASC )
)
)
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |