Forum Discussion
Solved
Show Same Value in Every Row
Hello all, I am trying to make a pareto chart and am running into issues on the last step. I need to divide Distinct Running Sum Categ/Distinct Total Sum Categ to get the Cumulative %. The paret...
Update- found a solution. This is the formula I used
= CALCULATE(SUMX(VALUES('Table'[Column]),[Distinct Sum Categ]),ALLSELECTED())I don't know if I explained it well enough in the initial question but I had a few filter fields to take into account as well as a date slicer and another category slicer. That made it tricky to write the formula to get the exact numbers I was looking for but it seems that ALLSELECTED takes those filters into account and I used a different measure for the expression field in SUMX.
Update- found a solution. This is the formula I used
= CALCULATE(SUMX(VALUES('Table'[Column]),[Distinct Sum Categ]),ALLSELECTED())
I don't know if I explained it well enough in the initial question but I had a few filter fields to take into account as well as a date slicer and another category slicer. That made it tricky to write the formula to get the exact numbers I was looking for but it seems that ALLSELECTED takes those filters into account and I used a different measure for the expression field in SUMX.