Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional Formatting based on other measure value no effect when blank

 I have a Matrix , I amusing the  condional Formating the Colors of the Values using a Field value  ...  .. which works .. But when there is no value for the Category ...  it defaults to White ... is...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    ElenaN 

    oldway

    COUNT(SuccessionPlanning[Employee Name])

     

    Newway

    count(SuccessionPlanning[Employee Name]) +0 

    I know it is weird ..
     
    I started researching how to delete with Blank in Dax .. but nothing looks simple@Elena
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    To update the measure as below should work well.

     

    measure = var a = count(SuccessionPlanning[Employee Name])
return
IF(ISBLANK(a),0,a)
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

To update the measure as below should work well.

 

measure = var a = count(SuccessionPlanning[Employee Name])
return
IF(ISBLANK(a),0,a)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-frfei-msft 

 

This worked great for the Card Visuals ... But for some reason , the Default Matrix Visual still does not like it ..    it is just weird ...  and that is the best visual to show this data ...

 

I looked at my other Matrix visual , that is using  the same logic and it now displays the zero ... Noticed that the Column Values are coming from a Valid Table of Values ...  I was deriving from the data ..

 

Thanks the solution works ... when I use a Reference Table for the Columns ...  If it only comes from the data , it seems to have a problem .. 

 

Thanks