Subtotal of Matrix is not Correct

[RSD]

Hi Team,

Subtotal of matrix is not coming correct.In Measuer Shipment Final the Subtotal is wrong. To Fix this i tried below formula:

Final Shipment = IF(HASONEFILTER('Forecast Code'[Master Date].[Year]),

CALCULATE(SUM('Forecast Code'[Shipment QTY]),DATESBETWEEN('Forecast Code'[Master Date],FIRSTDATE('Forecast Code'[Master Date]),

FIRSTDATE('Forecast Code'[Master Date])+14),ALLEXCEPT('Forecast Code','Forecast Code'[Customer],'Forecast Code'[Master Date].[Year],'Forecast Code'[BC]))

,CALCULATE(SUM('Forecast Code'[Shipment QTY]),DATESBETWEEN('Forecast Code'[Master Date],FIRSTDATE('Forecast Code'[Master Date]),

FIRSTDATE('Forecast Code'[Master Date])+14),ALLEXCEPT('Forecast Code','Forecast Code'[Customer],'Forecast Code'[Master Date].[Year])))

Could you please help me with this?

Regards,

RSD

[amitchandak]

@RSD , Check if can help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[RSD]

@amitchandak ,

Thank you so much for your help but I created new column instead of Measure , now it gives correct subtotal.

Thanks Again,

RSD