Count frequency using two criteria (similar to count.ifs in Excel)

[Ogos-DL]

Hello! I have been investigating for quite a bit and I haven't found a correct way to do this:

I have the current table:

I want to generate another table where you get the number of times 1 is repeated, 2, 3 and so on for each symbol.

This is how I picture it:

Symbol	#	Frequency
AUDCAD	1	8
NZDCAD	22	1
AUDCAD	2	5
...
...

In excel I would do it with Count.ifs, but in power BI I haven't found the way yet. I would be grateful If you could help me.

Thank you very much in advance!

[amitchandak · Accepted solution]

@Ogos-DL , I think you have to create bucketing on count measure

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[Ogos-DL]

Thank you!