Creating Invoice Net Amount USD Line in Power BI

Question

Hi, I hope this message finds you well. I am reaching out to seek your expertise and assistance in replicating a specific feature from a Tableau report into Power BI. The challenge I am currently facing is in creating an "Invoice Net Amount USD" line that displays percentages as shown in the Tableau report.

I have attempted to achieve this in Power BI using various approaches, but I haven't been successful in replicating the exact behavior. It appears that the DAX formula I have been using might not be suitable for this specific requirement.

Could you please guide me on the appropriate DAX formula or any other method to achieve a similar percentage display for the "Invoice Net Amount USD" line in Power BI?

I appreciate any insights or suggestions you can provide to help me overcome this hurdle. Thank you in advance for your time and assistance.

daniel29195 · Accepted Answer

hello&nbsp;Anonymous&nbsp;what you are trying to achieve is a cumulative %.&nbsp;&nbsp;&nbsp;&nbsp;sample data used :&nbsp;&nbsp;measure :&nbsp;&nbsp;code :&nbsp;Measure 14 =var cumlative = CALCULATE(&nbsp; &nbsp; SUM('Table (15)'[qty]),&nbsp; &nbsp; WINDOW(&nbsp; &nbsp; &nbsp; &nbsp; 0,&nbsp; &nbsp; &nbsp; &nbsp; ABS,&nbsp; &nbsp; &nbsp; &nbsp; 0,&nbsp; &nbsp; &nbsp; &nbsp; REL,&nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Table (15)',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Table (15)'[item]&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED( 'Table (15)'[item]))&nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; ORDERBY('Table (15)'[item], ASC )&nbsp; &nbsp; ))var total = &nbsp;CALCULATE(&nbsp; &nbsp; SUM('Table (15)'[qty]), ALLSELECTED( 'Table (15)'[item])&nbsp; &nbsp; )&nbsp; &nbsp; RETURN&nbsp; &nbsp; divide(cumlative, total, 0 )&nbsp; &nbsp; &nbsp;&nbsp;hope this works.Nb:&nbsp; &nbsp;the orderby in the window function, should be the same as the order of the visual .&nbsp;&nbsp;if the x-axis is randomly ordered, i would suggest to create a column to order this column .&nbsp;this can be done as follow :&nbsp;go to table view :&nbsp;select the column in questiongo to sort by columnchoose the index .&nbsp;&nbsp;&nbsp;&nbsp;hope this helps&nbsp;&nbsp;best regards.&nbsp;