Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create a Distribution chart by bucketizing a measure

Hello friends. Imagine my scenario as part of Supply Chain data where users are ordering items.       In this table, I created "Average (days)" as a measure that calculates the average days...
Need Help
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    Hi Anonymous 

     

    I created a bucket table with 3 columns: Bucket (ie. 0-10), Min(0) and Max (10) for each bucket.

     

    I wrote 1 measure.

     

    Count = 
    COUNTROWS(
        FILTER(
            ALL( 'Table' ),
            'Table'[Average (days)] >= SELECTEDVALUE( 'Buckets'[Min] )
                && 'Table'[Average (days)] <= SELECTEDVALUE( 'Buckets'[Max] )
        )
    )

     

     

    The ALL() might have to be changed to ALLSELECTED() depending on your needs.

     

    Let me know if you have any questions.

     

    Create a Distribution chart by bucketizing a measure.pbix

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Actually I cant. The logic to check user selection and get the average duration only works as a measure.

gmsamborn's avatar
gmsamborn
Super User
2 years ago

Hi Anonymous 

 

I created a bucket table with 3 columns: Bucket (ie. 0-10), Min(0) and Max (10) for each bucket.

 

I wrote 1 measure.

 

Count = 
    COUNTROWS(
        FILTER(
            ALL( 'Table' ),
            'Table'[Average (days)] >= SELECTEDVALUE( 'Buckets'[Min] )
                && 'Table'[Average (days)] <= SELECTEDVALUE( 'Buckets'[Max] )
        )
    )

 

 

The ALL() might have to be changed to ALLSELECTED() depending on your needs.

 

Let me know if you have any questions.

 

Create a Distribution chart by bucketizing a measure.pbix

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you! that worked.

     

    I'm trying to visualize this using bar charts. Would you be able to know how to create bins? Like for example, I want user to select bins of 10, 20, 30, 30 etc. Is there a way to show this? Also what if the duration between two tasks is like say 1000 days. 

     

    thanks