Forum Discussion
Cohort/Group comparisons
Hi rchappelle ,
This can be achieved using measures for example:
MAle = CALCULATE(AVERAGE( 'Table'[Priority]),'Table'[Gender] = "M") Female = CALCULATE(AVERAGE( 'Table'[Priority]),'Table'[Gender] = "F") Age 35 + = CALCULATE(AVERAGE( 'Table'[Priority]),'Table'[Age] >= 35) Location_ = CALCULATE(AVERAGE( 'Table'[Priority]),'Table'[Location] = "Leeds") Nationality Average = CALCULATE(AVERAGE( 'Table'[Priority]),'Table'[Nationality] in VALUES(Nationality[Nationality]))Then you can place it on a matrix and go to the options and turn on the option Show on Rows result below:
To make it dinamic you can create tables for slicers in this case I have done it for nationality and you can see based on the selection of the slicer the average gets calculated. You just need to do one for each of your variations.
PBIX file attach.
This is just one option depending on your model and needs you can do MGI, calculation groups and all sort of things.
Hi guys, i want to create a dashboard to compare two or three salespersons. Is there any idea on how i can go about it
Hi Moshood_AK ,
Without any data is difficult to give you a correct answer.
Please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).
Leads table containing data i want compareuser table containing the users we will be comparing
Hi Moshood_AK ,
The images are not very well perceived, can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.