Measure Column to Count based on Condition

[SAM_]

Dear All,

I am having the below table and I had created and want to have only one single Measure Column that tells about total number of Rows having for Sptin6 and total number rows in sprint5 ,Sprint4 etc...

can any one please help me how can I get it.

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

Thanks & Regards,

SAM_

[Uzi2019 · Accepted solution]

Hi @SAM_ 
Either take sprint 2 times in a table then change the aggregatiopn of 2nd sprint to count.

Or you can create measure seperately for Sprint count

Measure count = COUNT(SAM[Sprint])

I hope I answered your question!

[v-tianyich-msft · Accepted solution]

Hi @SAM_ ,

Thanks to @Uzi2019  solution, if you don't want to create a new table, you can refer to the following solution:

Count = var _t = ADDCOLUMNS('Table',"Count",COUNTAX(FILTER(ALL('Table'),[Sprint]=EARLIER([Sprint])),[Sno]))
RETURN MAXX(_t,[Count])

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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_ 
Either take sprint 2 times in a table then change the aggregatiopn of 2nd sprint to count.

Or you can create measure seperately for Sprint count

Measure count = COUNT(SAM[Sprint])

I hope I answered your question!

[Ashish_Mathur]

Hi,

Drag Sprint to a Table visual and write this measure

Measure = countrows(Data)

Hope this helps.

[SAM_]

@Ashish_Mathur  I am getting the total rows , But I am required to get the rows based on the sprint

[Ashish_Mathur]

I do not understand.  Show the expected result very clearly.