Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi guys, @Greg_Deckler or anyone who can help... 😕
first of all, thanks for having me...
my issue is the following:
I want to distinctcount the no of Trip Id's and filter by the inspection group.
The problem is that this does not add up. I know what the issue is. Some trips can be admin and physical, which are both under the same column header. (Same trip Id twice) In those cases only the physical trip but not the admin trip should be counted. I tried filtering on multiple criteria, but it does not work, probably because it is all under the same column header.
Any ideas how to fix this? Much obliged. Sandra
I can create a measure which counts if either of those criteria is applicable:
but when I try to create a measure that counts only the cases where both conditions apply, it does not work:
The measure is correct, but the card value shows blank even though there are cases that both criteria apply.
Hello,
Kindly provide the sample input/output in a usable format (excel, csv, table etc.) masking sensitive information.
reference : https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Thanks,
Hi @adudani ; @SachinNandanwar
Thank you very much for your assistance. I've replied earlier to your message but somehow it looks like it was not saved.
I will try to explain the problem a bit better.
I want to count the number of trips. I use the following formula to do that.
I have to somehow filter out the the Admin group when both categories apply.
Hope that makes sense. It's very hard to explain, but the short of it is that if both groups are included only the Physical Group should be counted for a particular inspection.
Thanks again, Sandra
Trip Inspection Id | Inspection Group | Inspection Category |
7230829588 | Administrative | Cross Checks |
7230829588 | Physical | Demersal Landings |
7230829588 | Physical | Multiannual Plan Species |
7230829543 | Administrative | Cross Checks |
7230829543 | Physical | Demersal Landings |
7230829543 | Physical | Multiannual Plan Species |
7230600288 | Administrative | Administrative/Non-Landing |
7230555293 | Administrative | Cross Checks |
Intially you mentioned that
"Some trips can be admin and physical, which are both under the same column header. (Same trip Id twice) In those cases only the physical trip but not the admin trip should be
counted."
and then you stated
"when I try to create a measure that counts only the cases where both conditions apply"
i think there are some discrepancies between the two.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |