Forum Discussion

mede's avatar
mede
Icon for Resolver I rankResolver I
9 years ago
Solved

Works with Intermediate measures, doesn't work with VAR. Why?

I am quite puzzled by how DAX behaves.   I am calculating dynamic sales value that changes based on currency selection. I have two intermediate measures:   Sales (at row) = SUM(Sales[net_sales_l...
  • mede's avatar
    mede
    9 years ago

    Actually, I have solved it with one formula:

    Sales Ultimate = IF(COUNTROWS(VALUES('FX Rates2'[FX]))=1,VALUES('FX Rates2'[FX])*SUM(Sales[net_sales_local]),SUMX(SUMMARIZE(Sales,'FX Rates'[Currency]),CALCULATE(VALUES('FX Rates2'[FX])*SUM(Sales[net_sales_local]))))
mede's avatar
mede
Icon for Resolver I rankResolver I
9 years ago

Actually, I have solved it with one formula:

Sales Ultimate = IF(COUNTROWS(VALUES('FX Rates2'[FX]))=1,VALUES('FX Rates2'[FX])*SUM(Sales[net_sales_local]),SUMX(SUMMARIZE(Sales,'FX Rates'[Currency]),CALCULATE(VALUES('FX Rates2'[FX])*SUM(Sales[net_sales_local]))))