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.
Looking for solution to evaluate multiple rows based on multiple categories. In my example, I want to know per site, per category - if all the documents in the sites' category are resolved for the site, then indicate in the result column - "Complete" for all those rows.
If any of the documents are not resolved in the particular category, then all the documents in this category would be marked in the result column as Incomplete.
I want to know, Yes a category is complete or No it isn't and be able to show the categories in my report by site. I was thinking a measure, but I am not certain. I am not sure how to ask for ALL the rows to meet the condition - where the column Status for each category = "Resolved" per site. All resolved = Complete If they are not all Resolved, then Incomplete.
Thank you
Solved! Go to Solution.
pls try this
RESULT =
VAR _t1 = CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]))
VAR _t2 = CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]),'Table'[Status]="Resolved" )
RETURN
if (_t1 = _t2 ,"Complete", "Incomplete" )
Thank you for addressing - it looked to work - but I added one more row on Site A for bikes #88, and it is not flagging the Cars as Complete. I think it needs to also look at the category, as the comparison is for a site, and also the rows in each category. Teh Site A rows for Cars are resolved - so the result should be Complete. I am getting Incomplete.
pls try this
RESULT =
VAR _t1 = CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]))
VAR _t2 = CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]),'Table'[Status]="Resolved" )
RETURN
if (_t1 = _t2 ,"Complete", "Incomplete" )
Thank you - this is working, I appreciate you!
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 |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
13 | |
9 | |
7 | |
6 |