Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Try 

CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),FILTER('Detail','Detail'[doc type]<>"Operating Lease" && 'Detail'[Doc type]<>"Contract Hire"))

 

If you want to remove other filters, add the ALL/ALLSELECTED function

CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),FILTER(ALL('Detail'),'Detail'[doc type]<>"Operating Lease" && 'Detail'[Doc type]<>"Contract Hire"))

or

CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),FILTER(ALLSELECTED('Detail'),'Detail'[doc type]<>"Operating Lease" && 'Detail'[Doc type]<>"Contract Hire"))

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This is still not picking up the data correctly 

 

Is there any other explanation for why it may not work?

 

The calculation method for the rest of the process is correct but its the first calculation which is the issue which means the results for the rest of the process are an issue