Forum Discussion
ClaireLin
4 years agoFrequent Visitor
Sum with condition
Table 1 Table 2 ===== ======================== Name Name ...
HotChilli
Community Champion
4 years agoIf you put a simple SUM as the aggregation for each KPI field, create a table visual with Name and each kpi field, then using the Filter pane (Advanced filtering), add the conditions you want to filter the name field (you can add multiple conditions with 'and'). You should be able to display the 2 rows with figures (and the totals will be correct)
So the output won't be exactly what you specified but powerbi doesn't like displaying rows with blanks.
Hope it helps.