Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need Urgent help

Hi, I want to create a histogram in power BI which will show count of user ids per their Sum of total revenue.   The thing is that I have to group the revenue like: 0-50 GBP, 51-100 GBP,101-150 GBP...
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Anonymous 

    if this is what you want : 

     

     

    then just modify the code to this : 

    Measure 9 = 
    var lowerbound = MIN(Segment_table[Min])
    var upperbound =  MAX(Segment_table[max])
    
    var ds = 
    FILTER(
       
            VALUES(Sheet1[UUID]),
      
        [Total Revenue] >= lowerbound && [Total Revenue]< upperbound
    )
    
    
    return COUNTROWS(ds)

     

     

    let me know if this works. 

     

     

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠