Displaying data in a Matrix - Showing last available data, as well as rows with no data

Community Support

6 years ago

Hi Anonymous ,

I create an example. Please check if this is what you want:

1. Two tables.

Table 1:

Table 2:

SubLocation	Year	Month	KPI
A1	2019	Oct	1
A1	2019	Nov	2
A1	2019	Dec	3
A1	2020	Jan	4
A2	2019	Oct	5
A2	2019	Nov	6
A3	2019	Oct	7
A3	2019	Nov	8
A3	2019	Dec	9
B1	2020	Jan	10
B2	2019	Nov	11
B2	2019	Dec	12
B3	2019	Oct	13
B3	2019	Nov	14
B3	2019	Dec	15
B3	2020	Jan	16

2. Create relationship.

3. Create a measure.

Measure = IF ( SUM ( 'Table 2'[KPI] ) = 0, "NULL", SUM ( 'Table 2'[KPI] ) )

For details, please check the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion