Forum Discussion

WasmerL's avatar
WasmerL
Frequent Visitor
5 years ago

Pareto Chart / Cumulativ Sum Issue

Hi All, I´m relativly new to Microsoft Power BI. My boss wants a Pareto Chart, the already availabe Pareto Chart from the custom visuals won´t do the job. So i decided to make my own. Im using a c...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

WasmerL , Try like

new measure =
var _t= ADDCOLUMNS(Summarize( Source, Source[product], "_1", sum(source[sales])), "_1", sumx(filter(source, sum(source[sales]) <= _1),[_1]))
return
Sumx(_t,[_2])

WasmerL's avatar
WasmerL
Frequent Visitor
5 years ago

Hi amitchandak , thank you for your fast reply. 
Sadly your solution wont work for me. It throws me an error at (see the screenshot):

With the message: 

"Fehler beim Auflösen von Name '_1'. Es ist kein gültiger Tabellen-, Variablen- oder Funktionsname." 
I really dont know why it wont work. I hope you can further help me. 

Again thank you in advance, 
kind regards