Forum Discussion
Helper IAdding four measures with non-blank values returns blank value, but not always?
I'm not sure how to even phrase this, but I have four measures that are working just fine. Then I have a fifth measure that adds the four measured values together.
The fifth measure works for one slicer selection, but returns blank for all others. All selections return normal values for the 4 measures I'm adding together, so the slicer should have no effect on the 5th measure's functionality.
Example:
Slicer selection 1 returns these values for the 4 measures: 100%, 100%, 53% and 47%. Measure 5 adds them to get 300%. Perfect.
Slicer selection 2 returns these values for the 4 measures: 100%, 100%, 68% and 45%. Measure 5 returns a blank value. WHY?
5th measure DAX is simply: 'Table'[measure 1] + 'Table'[measure 2] + 'Table'[measure 3] + 'Table'[measure 4]
Any ideas? Thanks in advance
4 Replies
- Greg_Deckler
Community Champion
Rosenshredder Where is the 5th measure being used? In a Card visual or something else?
RosenshredderYes, all 5 measures are being used in card visuals, and there are no differences in the filters applied to them.
- Greg_Deckler
Rosenshredder Any chance you can post the PBIX or sample data with instructions on how to recreate the issue?
