Forum Discussion
Duplicated rows when adding a measure to a table visual
- 2 years ago
The whole row is not duplicated. What you see is powerbi giving you all the combinations of the dimension and fact table for which the measure returns a non-blank value.
This part
IF( TotalAntal = 0, 0,returns a 0 for all rows where the measure Beholdning minus udløbet is 0. I don't know what that measure does but it looks like it returns 0 for all the combination that could be in the visual
--
In powerbi, we sometimes use this feature to our advantage by adding 0 to a measure, for example, show me all the customers who have sales and also show me the customers who have no sales. The measure above does something similar
--
In any powerbi visual, when a measure returns blank, the rows will be removed from that visual.
HotChilli Thank you for the explanation. The variable 'TotalAntal' uses 'ZMM_INDI - Uden dubletter'[Beholdning minus udløbet], which calculates how much is in stock minus the amount that has expired. I took over the data model from someone else, so I don't know why we want to show 0 instead of just blank.