2 Counts Vs 2 Filtters

[Anonymous]

HI All,

First I am new on power BI.......

I have 1 Table as below

Device ID             Maintenance Requist         Maintenance Result

1                              5/2019                                  12/2019

2                              1/2019                                  7/2019

3                              2/2020                                  null

4                              1/2020                                  6/2020

I have 2 slices (filter) one for Maintenance Requist, the other for Maintenance Result 

and 2 cards for count row, one for Maintenance Requist and the other for Maintenance Result.

my proble is ,,, when I filter only the Maintenance Result on 2020,  the count showes

Maintened : 1 "correct"

Requisted : 1 "wrong, Because the Maintenance Requist not filtered yet. it's supposed to show 4" 

So. I need the each count row is related to 1 filter regardless of other filters.

[amitchandak]

@Anonymous , Not very clear. But seem like you need to join you dates with a common date table and use userelation in the formula

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

[Anonymous]

amitchandak,, thanks for the reply...

I am sorry. maybe becacuse I am very new to Power Bi, I am not able to explain it well..

I have only one table ( i dont have relation ships) my problem with counts.

Device ID             Maintenance Requist         Maintenance Result

1                              5/2019                                  12/2019

2                              1/2019                                  7/2019

3                              2/2020                                  null

4                              1/2020                                  6/2020

lets assume I filtered on Maintenance Result on 2020... the result will be 

Device ID             Maintenance Requist         Maintenance Result

4                              1/2020                                  6/2020

so the count for maintence is 1 record.( wich is right). 

at the same time i filterd Maintenance Requist is 2019.. the count for Maintenance Requist is 0... ( this is wrong) 

the result should be 2 reocreds .....

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

You can use 'Edit interactions'.

Best regards,
Lionel Chen

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