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" )
Ashish_Mathur
Super User
Super UserHi,
Any reason to prefer a Power Query solution (M code) over a DAX solution (measure)?
EaglesTonyPost Prodigy
Post ProdigyI thought it would be easier to group by in Power Query.
- Ashish_Mathur
It is much easier with a measure as already shown by another contributor.