Context Filter Aggregation

[irfanelevated]

Hi,

I am new to PowerBI, In the below visual all looks good-

However, When I removed the column [Product] the value of Price MOM$ is not as expected.

It should be -26+7-19+2=-36

Any help would be appreciated.

Thanks,

Irfan

[Fowmy]

@irfanelevated 

Can you share the DAX formula for MOM$

[irfanelevated]

Hi,

Thank you for quick response.

Below is the formula-

Price MOM$ = IFERROR( ([PriceCM]-[PricePM]), 0)

PriceCM = MAX(Sheet1[PriceOfMonth])

PricePM = IF( CALCULATE([PriceCM],PARALLELPERIOD('Date'[Date],-1,MONTH))=BLANK(),[PriceCM], CALCULATE([PriceCM],PARALLELPERIOD('Date'[Date],-1,MONTH)))

[v-easonf-msft]

Hi, @irfanelevated 

Not  sure.

Try to add a new measure as below:

Price MOM$ =
SUMX (
    SUMMARIZE ( 'Sheet1', 'Sheet1'[supplier], "Measure1", [Price MOM$] ),
    [Price MOM$]
)

If it doesn't meet your requirement, please share you sample file for further research.

Best Regards,
Community Support Team _ Eason