Forum Discussion

AndrewDavies437's avatar
AndrewDavies437
Helper I
4 years ago
Solved

Help with DAX Query: Not including values that are 0

So I currently have a DAX query like this:   Average Commission R12 =   CALCULATE( SUM( 'Rolling 12 Month Transaction Report'[Total Income]),   'Rolling 12 Month Transaction Report'[Total I...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    AndrewDavies437 , use divide and try

     

    divide( SUM(
    'Rolling 12 Month Transaction Report'[Total Income]), SUM(
    'Rolling 12 Month Transaction Report'[Discounted Premium]))

amitchandak's avatar
amitchandak
Super User
4 years ago

AndrewDavies437 , use divide and try

 

divide( SUM(
'Rolling 12 Month Transaction Report'[Total Income]), SUM(
'Rolling 12 Month Transaction Report'[Discounted Premium]))

  • AndrewDavies437's avatar
    AndrewDavies437
    Helper I
    4 years ago

    Thank you for the hasty and correct response! This works perfectly. Have a great day 🙂