Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |