Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |