Forum Discussion
Create single measure for frequency distribution comparison
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.
Community SupportHi 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.