cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samarth-Borade
Frequent Visitor

Calculate the total count of occurence of values in a measure

I have a MEASURE : Max Trip ,

It contains values :"Monday", "Tuesday" , "Wednesday" , "Thursday" , "Friday" , "Saturday" , "Sunday".

i want a measure which counts the ouccrence of them as below image :

 
 
Max TripOccurence
Monday2
Wednesday1
Monday2
Friday1
 4
 
 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Samarth-Borade ,

 

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

 

text example

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q



!! 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

@Samarth-Borade ,

 

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

 

text example

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q



!! 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! !!

Can you please drop the code for this , it will be really helpful!

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