Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Show items with no data on new update

Hi all, On the previous update, to show items with no data, we simply had to go to the viz pane, click the arrow on the field and select 'Show items with no data'. The problem I have is that ther...
  • Anonymous's avatar
    Anonymous
    2 years ago

    You would then have to create a DAX measure to test if selected attribute related to value has no value. We have used this for a SUM:

    ValueNoValue SUMx = SUMX( 'TableName', Sum( TableName[ColumnToSum] ) + )