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.