Measure to have Multiple Countrows based on Conditions

[SAM_]

Dear All,

I Created a Measure to get the total issues where Status is "Done" for Sprint="6" using below table for the measure

SprintCount =CALCULATE(COUNTROWS('Sheet1'),'Sheet1'[Sprint] = "Sprint6",'Sheet1'[Status] = "Done") and I am able to get the result too.

Sno	Issues	Status	Sprint
1	768	Done	Sprint6
2	888	Done	Sprint6
3	666	QA in Progress	Sprint6
4	999	Deployed in Prod	Sprint6
5	567	Done	Sprint5
6	900	Done	Sprint5
7	100	In-Progress	Sprint5

But when I use nestead CountRows as below I am unable to get the result 

SprintCount =CALCULATE(COUNTROWS('Sheet1'),'Sheet1'[Sprint] = "Sprint6",'Sheet1'[Status] = "Done") , COUNTROWS('Sheet1'),'Sheet1'[Sprint] = "Sprint5",'Sheet1'[Status] = "Done") .

Can any one please help me in knowing whats wrong in the above Measure for nestead Measure

Thanks & Regards,

SAM_

[Uzi2019 · Accepted solution]

Hi @SAM_ 
Add Sprint column to the chart for bifurcation 
or
Create seperate measure for sprint5 condition and sprint 6 condition.

[Greg_Deckler]

@SAM_ Try this:

SprintCount =
COUNTROWS(FILTER('Sheet1', [Sprint] = "Sprint6" && [Status] = "Done") 
+
COUNTROWS(FILTER('Sheet1', [Sprint] = "Sprint5" && [Status] = "Done") 

[SAM_]

@Greg_Deckler  Thanks for rapid response .

I would like to have 2 results in 1 measure , But not summing it . As you can see there is stacked chart for sprint6 for measure  SprintCount =CALCULATE(COUNTROWS('Sheet1'),'Sheet1'[Sprint] = "Sprint6",'Sheet1'[Status] = "Done") and beside it I want to have result of Sprint 5 in same chart for comparision.

[v-rzhou-msft · Accepted solution]

Hi @SAM_ ,

I think  Uzi2019  's reply describes workaround but not detailed enough. I'll walk you through the exact process on my end.

According to your statement, I think you can try to add the [Sprint] column in X-axis and add below measure in Y-axis to create a clustered column chart.

Measure:

SprintCount = CALCULATE(COUNTROWS('Sheet1'),'Sheet1'[Status] = "Done")

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019 · Accepted solution]

Hi @SAM_ 
Add Sprint column to the chart for bifurcation 
or
Create seperate measure for sprint5 condition and sprint 6 condition.