Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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_
Solved! Go to 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!
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.
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.
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!
Hi,
Drag Sprint to a Table visual and write this measure
Measure = countrows(Data)
Hope this helps.
@Ashish_Mathur I am getting the total rows , But I am required to get the rows based on the sprint
I do not understand. Show the expected result very clearly.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |