Forum Discussion
Create measures fixing columns
Hi, I have this table below (example), and I need to do some Measures to show them in a dashboard with slicers.
Country | GROUP | Month | Market | Client_Type | Sales_Channel | Unsubscribe 1st month | Unsubscribe 3rd month | Unsubscribe 6th month | New Contracts |
Spain | Control | 201901 |
|
| Phone | 5 | 2 | 4 | 8 |
France | A | 201901 |
|
| Internet | 2 | 1 | 2 | 9 |
Germany | B | 201902 |
|
| Office | 0 | 1 | 3 | 6 |
Italy | C | 201901 |
|
| Internet | 1 | 3 | 2 | 10 |
I would need to create 2 kind of measures:
- Ratio 1stMonth: Unsubscribe 1stMonth/New Contracts
- Delta Groups 1Month: Ratio 1stMonth (Group=Control) - Ratio 1stMonth (Group= X). X =A,B, C...etc .The intention is toshow in a table, all groups (A, B, C...etc) Deltas, with any variable filtered (in slicers) if needed, between the control group and the analized group.
Its being a pain to do this, specially measures 2, because I cannot do that operation. Can anyone help me please?
Thank you so much in advance
1 Reply
antonioaceituno , not very clear. Refer if this can help
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
