Forum Discussion
2 Counts Vs 2 Filtters
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.
Hi Anonymous ,
You can use 'Edit interactions'.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , Not very clear. But seem like you need to join you dates with a common date table and use userelation in the formula
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-msftCommunity Support
Hi Anonymous ,
You can use 'Edit interactions'.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
