Forum Discussion

DivakarKrishnan's avatar
DivakarKrishnan
Icon for Helper II rankHelper II
6 years ago

Handling blank values and ignoring additional fields DAX

Dear Team,   I am using below DAX values in my below matrix visual. However, I am seeing many blank values. DAX 1: Issue_SR_Open_Ageing = CALCULATE(COUNT(Issues[Created week] ),FILTER('Issues','I...
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

DivakarKrishnan 

You cannot fill all the cells with blank to ZERO when you do not have data for the intersection of ROW and Column. Your measure DAX2 will not work in that case.

Blocker, Critical, High are showing up as the measure is able to produce a blank value.


________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

  • DivakarKrishnan's avatar
    DivakarKrishnan
    Icon for Helper II rankHelper II
    6 years ago

    ok, but any other work around or suggestion to handle this scenario please. Requirement is they don't want to see blank values.