Forum Discussion

Fredrikwahl's avatar
Fredrikwahl
New Member
3 years ago

Calculation without relation to date filters

Hi,   I have a problem. I'm tryin to calcutate the profitof a certain product. This containt two calculations; - Revenue carparts - Cost carparts    Both of these calculations come from the sam...
Need Help
Padycosmos's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago

Please try the following:

Cost carparts =
CALCULATE(SUM(Hovedbok[Amount]),
            Filter(Hovedbok,Hovedbok[AccountNo]>=4040 && Hovedbok[AccountNo]<=4048))
  • andhiii079845's avatar
    andhiii079845
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Okay, you can filter your measures via date table:

    - Revenue january 2023

    - Cost all time 

    But the third measure do not use the filter, because of the missing relationship?