Sum of Column In grand Total

[Vaneet05]

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 

[Vaneet05]

@PaulDBrown Please help.

[PaulDBrown · Accepted solution]

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.

[ghoshabhijeet]

@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.

[Vaneet05]

@ghoshabhijeet 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.