Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am needing help on how to get the count or total of each different category value from both the "VOC Issue" and "VOC Issue 2" combined. Below is my data and then an example of the results I'm looking for.
Behavior | 4 |
Billing | 4 |
Change | 1 |
General | 1 |
Technology | 1 |
Solved! Go to Solution.
=Table.Group(Table.FromColumns({Table.Column(PreviousStepName,"VOC Issue")&Table.Column(PreviousStepName,"VOC Issue 2")},{"VOC Issue"}),"VOC Issue",{"Count",Table.RowCount})
=Table.Group(Table.FromColumns({Table.Column(PreviousStepName,"VOC Issue")&Table.Column(PreviousStepName,"VOC Issue 2")},{"VOC Issue"}),"VOC Issue",{"Count",Table.RowCount})
Thanks for the response, but it still a bit new to this. Could you explain a bit? Also would this be added as "new column" or "new measure"? I tried copying it into both and got errors.
this is a M code, not DAX
Hi, @wdx223_Daniel provided Power Query solution - so you should add his code as a new step in your Power Query query.
=Table.Group(Table.FromColumns({Table.Column(PreviousStepName,"VOC Issue")&Table.Column(PreviousStepName,"VOC Issue 2")},{"VOC Issue"}),"VOC Issue",{"Count",Table.RowCount})
The above provided code has PreviousStepName two times, you have to replace both with last step of your query. Just start writing name of last step of your existing query, like in attached image below, started writing changed Type and it will auto detect the name in proper format, select that for both the instances.
Hope it helps.
I did that and now I get an expression error of 'PreviouseStepName' not recognized.
I don't know what that is/means. Like I said I am still fairly new this. Could you explain a bit?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
45 | |
28 | |
14 | |
13 | |
13 |