Multiple Date columns in matrix

[Anonymous]

Right here is my sample data. 

Name  Area              KPI1             KPI1 Date      KPI2              KPI2 Date

a	London	Completed	11/03/2021	Completed	01/03/2021
b	Manchester		25/02/2021	Completed	01/03/2021
c	Chester	Completed	01/03/2021	Completed	11/03/2021
d	Leeds		25/02/2021		03/02/2021
e	London	Completed	01/03/2021		03/02/2021
f	Chester	Completed	11/03/2021	Completed	12/02/2021
g	Leeds	Completed	11/03/2021	Completed	12/03/2021
h	Glasglow		01/01/2021	Completed	05/01/2021

Without creating multiple tables for each KPI, I need to find a solution that will allow me to filter the count of KPI's completed by their corresponding date. For example: If I filter the highlighted below KPI 1 date for all outputs before the 11th of Match, I don't want to lose KPI2 output or vice versa. 

I can achieve this by creating multiple tables for each KPI but it's not a great solution for me. 

Any advice would be appreciated. 

Karlos. 

[AnkitKukreja]

Hi @Anonymous ,

You can use date table in your model and have a direct active with KPI1 date and inactive relationship with KPI2 date.

Then use slicer as date from your date table (it's a must for PBI model). Then just create 2 measures where you can count KPI1 and KPI2.

Thanks,

Ankit

[Anonymous]

Hey Thanks for the reply, 

That's actually the direction I've taken it, however, because both measures are in the same table, once I slice either KPI1 by KPI 1 date it will alter KPI 2 and vice versa. It would be fine if I had the measures outside of the same table but for the solution, I'm working with, that's not possible.