Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Can you provide the pbix of the sample data? I don't quite understand what the doc type is. The attachment is the pbix file I created by myself, you can refer to it.

 

 

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
CH/OL% = DIVIDE(SUM('Key Measures'[CH/OL],SUM('Key Measures'[CH/OL])+SUM('Key Measures'[1 HP/FL]),0))
 
Why does this calculation not work for me? it wont pick up the table that the columns are in
also this message comes up
 
Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Sorry, not very clear, can you provide me with pbix file? Remember to hide private data.

     

    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
    CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),'detail'[doc type]<>"Operating Lease",'detail'[Doc type]<>"Contract Hire")
     
    Im using this but its not actually picking up the data correctly 
    What is wrong with the calculation
    • 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