Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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.
@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 .....
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |