Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table that has a status column and it lists the following three options:
In Progress
Complete
Late
I want to count only the number of items listed as In Progress and Late.
I know how to do it for one, but don't know how to calculate the number of items for more than one status.
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below sample can provide some ideas on how to create a solution for your datamodel.
Progress or late count measure: =
COUNTROWS ( FILTER ( Project, Project[Status] IN { "In Progress", "Late" } ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below sample can provide some ideas on how to create a solution for your datamodel.
Progress or late count measure: =
COUNTROWS ( FILTER ( Project, Project[Status] IN { "In Progress", "Late" } ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Anonymous !
You can do the following:
CALCULATE(
COUNT( ItemsColumn ),
StatusColumn IN {"In Progress", "Late"}
)
Let me know if that helps!