Forum Discussion

Post Prodigy

2 years ago

Solved

Can you group by multiple columns?

hi, I have the following data: FeatureKey IssueKey IssueStatus IssuePoints abc-1 abc-5 Done 2 abc-2 abc-7 Ba...

2 years ago

Assuming your Count is a measure, you can use CALCUALTE to get the two additional values you are looking for.

Count = COUNTROWS ( YourTable )

Count-DoneItems = CALCULATE ( [Count], YourTable[IssueStatus] = "Done" )

Count-NotDoneItems = CALCULATE ( [Count], YourTable[IssueStatus] <> "Done" )

Super User

2 years ago

Make a measure to sum the count count column then you can use that in the CALCUALTE measures.

EaglesTony
Post Prodigy
2 years ago
I would think I use calculate first and then count ?
EaglesTony
Post Prodigy
2 years ago
I ended up using a new column:

TotChildCount =
var curParent = Merge1[Key]
var final = COUNTROWS(FILTER(Merge1, Merge1[Key] = curParent))
Return IF(final = BLANK(),0,final)

and

TotChildCountDone =
var curParent = Merge1[Key]
var final = COUNTROWS(FILTER(Merge1, Merge1[Key] = curParent && Merge1[Issues.ISSUE_STATUS_NAME] = "Done"))
Return IF(final = BLANK(),0,final)