Forum Discussion
EaglesTony
Post Prodigy
Post ProdigyCan 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...
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" )
jdbuchanan71
Super User
Super UserMake a measure to sum the count count column then you can use that in the CALCUALTE measures.