cancel
Showing results for 
Search instead for 
Did you mean: 
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

 

 



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

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

 

 



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Thank you!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors