Measures computes correctly only in a separate table

[helgi1507]

Hi!

I want to calculate 2 measures in the table, but they computes correctly only in a separate table.

Please help...

I've built a star-schema model, where:

[StoreID] - is unique store
[ChainID] - a group of unique stores

[CostItemID] - unique cost name
[AccountKey] - a group of costItems

Main measure:

Cost Amount TY = SUM(FactCosts[CostAmount])

Measures with conditions:

Salary = CALCULATE([Cost Amount TY], DimCostItem[CostItemID] = 876)

92 Account = CALCULATE([Cost Amount TY], DimAccounts[AccountKey] = "92")

Highlighted green where calculations correctly. In a columns - DimStoresChain[ChainID]

Model

[MohammadLoran25]

Hi @helgi1507 ,

Not Clear. I did not understannd your photos.Please explain more.