Forum Discussion
Solved
Pivot a pivot
Hi, Can someone help me with this? I have Table A as shown below and i would like to count the number of ProposalID each person has (Table B). Thereafter, i would like to have another table or c...
Hi paxdolphin ,
1.In desktop, create a measure like
Count = CALCULATE(COUNT('Table'[ProposalID]),FILTER(ALLSELECTED('Table'),[Name]=MAX('Table'[Name])))2.In Power Query, select the 'Name' and right click 'Group by'.
Select 'Count Rows' and click OK.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can simply select the name and proposal ID fields and click bar graph to get the expected output: