Forum Discussion
Helper ISum of Column In grand Total
Dear Team,
My workbook in Table contains column name FY 2022-23 Price Erosion .logically it gives me the correct number in the total but I want to sum that particular column in the total. Item wise value should be the same as given but in the grand total it should give me the sum of all values.
Workbook link- https://drive.google.com/file/d/1C5DOR6faiHnYGpxVaT41G0Yt8go-tabr/view?usp=sharing
Example link -https://drive.google.com/file/d/1JH4dljbDTd4j4b109x48i0MH_xX3_VE5/view?usp=sharing
In Example Link value of FY 2022-23, Price Erosion is the sum of that column which I want the same in my powerbi workbook
Try:
FY 2022-23 Price Erosion = SUMX ( 'Product', CALCULATE ( IF ( [Actual quantity 2022-23] > 0, ( [FY 2022-23 ASP] - [FY 2021-22 ASP] ) * [Actual quantity 2022-23], ( [FY 2022-23 ASP] - [FY 2021-22 ASP] ) * [Actual quantity 2021-22] ) ) )
5 Replies
- ghoshabhijeet
Solution Supplier
Vaneet05 I have checked both the link you shared and it seems both are at same. Please help me understand if I am missing something.
Vaneet05ghoshabhijeet First link is of Pbix and the second link is a CSV file. You need to download both and output already in Csv same needs to implement in Pbix.
- Vaneet05
PaulDBrown Please help.
PaulDBrownCommunity Champion
Try:
FY 2022-23 Price Erosion = SUMX ( 'Product', CALCULATE ( IF ( [Actual quantity 2022-23] > 0, ( [FY 2022-23 ASP] - [FY 2021-22 ASP] ) * [Actual quantity 2022-23], ( [FY 2022-23 ASP] - [FY 2021-22 ASP] ) * [Actual quantity 2021-22] ) ) )- Vaneet05
Thankyou it works.
