Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Ogos-DL
Regular Visitor

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

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:

OgosDL_1-1674047349203.png

 

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
AUDCAD18
NZDCAD221
AUDCAD25
...  
...  

 

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!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

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

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

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

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.