Forum Discussion
COUNTIF & COUNTIFS
Hi all, I'm trying to replicate the following Excel formula in a column that lives in PowerBI, and I'm having some trouble. The formula should pull complete if all items for a certain grouping are...
Anonymous
Ads this as a column to your table:Status = IF( CALCULATE( COUNTROWS(Table1) , Table1[Item Status] = "Incomplete", ALLEXCEPT(Table1,Table1[Grouping])) > 0, "Incomplete", "Complete" )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super UserAnonymous
Ads this as a column to your table:
Status =
IF(
CALCULATE( COUNTROWS(Table1) , Table1[Item Status] = "Incomplete", ALLEXCEPT(Table1,Table1[Grouping])) > 0,
"Incomplete",
"Complete"
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂