Sum of measure for dimension

[srlabhe123]

Hi All,

I am facing an issue in makeing sum of value for certain value of dimenssion.

Please check below figure I wanted to have Actual cost where Yesterday = Y and Plant =1400 , but when i use formula below 

ActualCostSAP = calculate(SUM(SAPView,SAPView[Actual Cost]),FILTER(SAPView,SAPView[YESTERDAY]="Y" && [SelectedPlant]=SAPView[PLANT]))

it givesme result as 101,081.88 while its right value is  33693.96

Check the below figure , it seems my DAX formula is not filtering out the row for 1400 and period, PLease note the Plant and period is selected from slicer as shown below 

[v-danhe-msft]

Hi @srlabhe123,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @srlabhe123,
Your formula with the SUM function looks stange, should it be SUMX( ) or  SUM(SAPView[Actual Cost])?

If you want to show the measure in the table visual, I suggest ues this modified formula:

ActualCostSAP = calculate(SUM(SAPView,SAPView[Actual Cost]),FILTER(ALL(SAPView),SAPView[YESTERDAY]="Y" && [SelectedPlant]=SAPView[PLANT]))

It it dosen't work, could you please share the sample pbix file to have a test?  You could upload your file to OneDrive or Dropbox and send the link here.

Regards,

Daniel He