Forum Discussion
Helper IReplacing null values in matrix visual
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,
Helper II am new to power BI so maybe i did this wrong? I: clicked the table-->New measure-->wrote in what's in the screenshot-->dragged the newly created 'number of faculty' measure to my values field. but then the table couldn't be displayed (the table is very similar to the 2nd table below it. i want to replace all the blank values with '0'
Community ChampionWait, is that measure you are pointing to what is being used in your current table visualization? If that is the case:
Measure = IF(ISBLANK([your current measure name]),0,[your current measure name])
Can you click on See details and tell us what it says?
- elopez
based on your 2nd message, i am unsure if i need to change what i wrote in the original measure?
v-lid-msftCommunity Support
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
I tried it and it doesn't do anything:
- v-lid-msft
Hi elopez ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,