Forum Discussion
Create single measure for frequency distribution comparison
I am working with a trip data set that identifies when trips start & end. There are 2 users in scope: member & casual.
I am trying to create a distribution graph to show the differences in trip start/end behavior by comparing member vs casual users.
Here is a sample of the data table & a pivot table to summarize the data characteristics.
I am trying to create a calculated measure that I can use to compare casual vs member.
I tried using 'count rows' to aggregate ride data, but this does not work because I do not have equal # of data points for both casual & member rides.
I think I need to compute % of total rides done to identify in which hour people are riding in a day and then visualize this on a line graph. Any suggestions?
I tried asking the same question in a different post but wasn't able to resolve it: https://community.powerbi.com/t5/Desktop/Normalize-multiple-values-to-show-relative-comparison/m-p/2124145#M785665
Hi JJH_
If possible, until then you can provide pbix files, which do not contain sensitive data. Or a table rather than a screenshot.
I have created some aggregated data based on your table. to show the method I am using.
When not using measure it shows similar results to the visual you have in another post.
And try this measure:
compare = VAR _member = SUM( 'Table'[Continue T rows] ) * 0.05 VAR _casual = SUM( 'Table'[Continue T rows] ) * 0.95 RETURN IF( MAX( 'Table'[type] ) = "member", _member, _casual )And the result:
If you want to create a table to calculate the number of people appearing over a period of time based on a time duration table, this is a post you can refer to.
I put my pbix file in the attional you can reference.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-chenwuz-msft
Community Support
Hi JJH_
If possible, until then you can provide pbix files, which do not contain sensitive data. Or a table rather than a screenshot.
I have created some aggregated data based on your table. to show the method I am using.
When not using measure it shows similar results to the visual you have in another post.
And try this measure:
compare = VAR _member = SUM( 'Table'[Continue T rows] ) * 0.05 VAR _casual = SUM( 'Table'[Continue T rows] ) * 0.95 RETURN IF( MAX( 'Table'[type] ) = "member", _member, _casual )And the result:
If you want to create a table to calculate the number of people appearing over a period of time based on a time duration table, this is a post you can refer to.
I put my pbix file in the attional you can reference.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
