Forum Discussion

bunkertrust's avatar
bunkertrust
Frequent Visitor
6 years ago

DAX Calculate is calculating wrong lines

Hi  I am trying to calculate different fuel quantity losses using the DAX calculate. Problem is that it is also calculating the lines that are not relevant for the specific fuel type.   We have IF...
Need Help
bunkertrust's avatar
bunkertrust
Frequent Visitor
6 years ago

Hi Pravin,

 

So you mean: 

IFO Loss MT = calculate(SUM('bunkertrust_com_db vBunkerOperationsFirstView'[bunker_ifo_received_vessel_figure]), FILTER('bunkertrust_com_db vBunkerOperationsFirstView', 'bunkertrust_com_db vBunkerOperationsFirstView'[bunker_ifo_received_vessel_figure]="IFO")) - CALCULATE(SUM('bunkertrust_com_db vBunkerOperationsFirstView'[bunker_ifo_departure_bdn]))))
 
This comes with syntax is incorrect
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

You have added to many parenthesis.

 

try this

 

IFO Loss MT = calculate(SUM('bunkertrust_com_db vBunkerOperationsFirstView'[bunker_ifo_received_vessel_figure]), FILTER('bunkertrust_com_db vBunkerOperationsFirstView', 'bunkertrust_com_db vBunkerOperationsFirstView'[bunker_ifo_received_vessel_figure]="IFO")) - CALCULATE(SUM('bunkertrust_com_db vBunkerOperationsFirstView'[bunker_ifo_departure_bdn]))

 

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • bunkertrust's avatar
    bunkertrust
    Frequent Visitor
    6 years ago

    Hi Pravin,

     

    This is coming with circular dependency in stead. 

    The figures are coming in separated columns, so I suppose it is a matter of not calculating if blank?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    share some sample dataset and expected output so that it will be easy for me to answer your quetion.

     

    Thanks,

    Pravin