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 Experts
i am trying to work out the following based on the table below...
If Worktype = RW and MEUCOMPLIANCEIMPACT = 1 and Status <> "CAN", then count or otherwise Worktype = "REMST" and
Measure
Solved! Go to Solution.
@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Tried the following still not working
Hi Greg See sample data as text - the expected end result is 4 as we have no MEUCOMPLIANCEIMPACT = 1 where WorkType = RW...but we have REMST we count those values and we have 4 of those as per below
Count | Worktype | Status | MEUCOMPLIANCEIMPACT |
1 | RW | PPM | 0 |
1 | RW | PPM | 0 |
1 | RW | PPM | 0 |
1 | RW | PPM | 0 |
1 | REMST | PPM | 0 |
1 | REMST | PPM | 0 |
1 | REMST | PPM | 0 |
1 | REMST | PPM | 0 |
User | Count |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
39 |