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)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

ElenaN 

 

Just tried that , did nothing ... I am doing a simple count(EmployeeName)   But the Employee will l be only in one column ... there are 6 possible choices ...   that is why it is tricky ...

On the tool tip it shows the value [BLANK]   but it would not take the + 0

ElenaN's avatar
ElenaN
Resolver V
7 years ago

So, you changed your measure from 'count(EmployeeName) ' to 'count(EmployeeName) + 0' and still does not show 0 in your matrix? 

 

Regards,

ElenaN

  • Anonymous's avatar
    Anonymous
    Not applicable
    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
      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