Forum Discussion

aslan's avatar
aslan
Icon for Helper I rankHelper I
9 years ago

Matrix Conditional Formatting

I want to give red color background if total value is greater than 10. And if less than 10 is should be green. But there is no option. Do you know any way?
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

 Hi there, 

 

how do I return zero(0) when the field value is empty using the following DAX function (Divide).

 

Avg. Sales = Divide([total sales] , [total transactions])

 

Thank you,

Imran

  • anandav's avatar
    anandav
    Icon for Skilled Sharer rankSkilled Sharer
    8 years ago

    Anonymous,

     

    Try:

    Avg. Sales = Divide([total sales] , [total transactions], 0)

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you this actually works.