Forum Discussion

elopez's avatar
elopez
Helper I
6 years ago
Solved

Replacing null values in matrix visual

Hi,    I created a table using the matrix visual. My values are sums of number of records in a field (named 'Faculty Rank' and once I drag that field under values, I choose the Count option). I wan...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi elopez ,

     

    Based on my research, If your table does not have at least one row record in the blank cell (such as our following example), the measure will not calculate at all:

     

     

    We can use a separated table such as following to meet your requirement

     

    Calculated Table:

     

    Column = DISTINCT('Table'[Column])

     

     

    Measure:

     

    Measure Value = CALCULATE([Measure]+0,'Table'[Column] in DISTINCT('Column'[Column]))

     

     

     


    By the way, PBIX file as attached.


    Best regards,

     

elopez's avatar
elopez
Helper I
6 years ago

based on your 2nd message, i am unsure if i need to change what i wrote in the original measure?

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi elopez ,

 

Based on my research, If your table does not have at least one row record in the blank cell (such as our following example), the measure will not calculate at all:

 

 

We can use a separated table such as following to meet your requirement

 

Calculated Table:

 

Column = DISTINCT('Table'[Column])

 

 

Measure:

 

Measure Value = CALCULATE([Measure]+0,'Table'[Column] in DISTINCT('Column'[Column]))

 

 

 


By the way, PBIX file as attached.


Best regards,

 

  • elopez's avatar
    elopez
    Helper I
    6 years ago

    I tried it and it doesn't do anything: