I used the RELATED formula to to create a Calculated Column called fact_ActualsOrders_ES[Accrual] or "Accrual":
=IF(related(dim_posting[doc_type_cd])="YK",1,0)
The values came over correctly, so I created (3) measures to calculate the the total amount, all the "1"s, and all the "0"s:
Measures: DAX Fx:
TotalActuals: 87260798.67 TotalActuals:=SUM([amount])
RealActuals: 81663153.41 RealActuals:=CALCULATE(SUM(fact_ActualsOrders_ES[amount]), fact_ActualsOrders_ES[Accrual]=0)
Accruals: 5597645.26 Accruals:=CALCULATE(SUM(fact_ActualsOrders_ES[amount]), fact_ActualsOrders_ES[Accrual]=1)
Everything worked perfectly. Then I refresh the data and the "Accruals" measure becomes 0, even though there are still many "1"s in the "Accrual" Calculated Column. Also, the "Total Actuals" and "Real Actuals" become equal.
Can anyone explain this behavior? Refreshing the data shouldn't change the value of the measures in this way.
=IF(related(dim_posting[doc_type_cd])="YK",1,0)
The values came over correctly, so I created (3) measures to calculate the the total amount, all the "1"s, and all the "0"s:
Measures: DAX Fx:
TotalActuals: 87260798.67 TotalActuals:=SUM([amount])
RealActuals: 81663153.41 RealActuals:=CALCULATE(SUM(fact_ActualsOrders_ES[amount]), fact_ActualsOrders_ES[Accrual]=0)
Accruals: 5597645.26 Accruals:=CALCULATE(SUM(fact_ActualsOrders_ES[amount]), fact_ActualsOrders_ES[Accrual]=1)
Everything worked perfectly. Then I refresh the data and the "Accruals" measure becomes 0, even though there are still many "1"s in the "Accrual" Calculated Column. Also, the "Total Actuals" and "Real Actuals" become equal.
Can anyone explain this behavior? Refreshing the data shouldn't change the value of the measures in this way.