I have a table name sales and trying to calculate % off gross for each value. I tried numerous dax formulas but couldnt get it to work in Power BI.
Does any one know how to calculate % of Gross for each row in below table in Power BI with dax formula?
Sample
Does any one know how to calculate % of Gross for each row in below table in Power BI with dax formula?
Sample
Calendar Year | Customer | PL Line | Values | % of Gross |
2019 | ACME Markets | Volume | 1972240 | |
2019 | ACME Markets | Gross | 697503 | |
2019 | ACME Markets | Returns | 0 | |
2019 | ACME Markets | Discounts | 3398 | |
2019 | ACME Markets | OSG | 206648 | |
2019 | ACME Markets | NS | 206224 | |
2019 | ACME Markets | Contribution | -109594 |