Forum Discussion
Segmentation not working, why?
I have the next model in SSAS cube:
Revenue [Key_Customer] | *:1 | << To Revenue | Client [Key_Customer] |
ClientType [ClientNo] | *:1 | << To Both Tables >> | Client [ClientNo] |
In my pbix, when in a visualization (ie matrix), I put revenue from ‘Revenue’ table and type from ‘ClientType’ table; the segmentation doesn’t work, I get all totals like:
Type | Revenue |
A | 2000 |
B | 2000 |
C | 2000 |
D | 2000 |
E | 2000 |
Total | 2000 |
Why do I get this behavior, if the revenue can be segmented? it can reach type through ClientType -> Client -> Revenue
6 Replies
I have the next model in SSAS cube:
Revenue [Key_Customer]
*:1
<< To Revenue
Client [Key_Customer]
ClientType [ClientNo]
*:1
<< To Both Tables >>
Client [ClientNo]
In my pbix, when in a visualization (ie matrix), I put revenue from ‘Revenue’ table and type from ‘ClientType’ table; the segmentation doesn’t work, I get all totals like:
Type
Revenue
A
2000
B
2000
C
2000
D
2000
E
2000
Total
2000
Why do I get this behavior, if the revenue can be segmented? it can reach type through ClientType -> Client -> Revenue
I have the next model in SSAS cube:
Revenue [Key_Customer]
*:1
<< To Revenue
Client [Key_Customer]
ClientType [ClientNo]
*:1
<< To Both Tables >>
Client [ClientNo]
In my pbix, when in a visualization (ie matrix), I put revenue from ‘Revenue’ table and type from ‘ClientType’ table; the segmentation doesn’t work, I get all totals like:
Type
Revenue
A
2000
B
2000
C
2000
D
2000
E
2000
Total
2000
Why do I get this behavior, if the revenue can be segmented? it can reach type through ClientType -> Client -> Revenue
- Fowmy
Super User
Having difficulty understanding the model, could you post a picture of your model and the DAX formula?
- AllisonKennedy
Community Champion
Anonymous I don't understand the shorthand you've used where you say 'to both tables'
Does one client have many client types? If so, the cross filter direction won't enable client type to filter client, it will only allow client to filter both client type and revenue, and that's why you're getting the results
- v-easonf-msft
Community Support
Hi, Anonymous
Could you please share a sample file further research?
Best Regards,
Community Support Team _ Eason
- Fowmy
Anonymous
Have you got three identical questions repeated?
https://community.powerbi.com/t5/Desktop/Segmentation-not-working-in-pbix/m-p/2070830
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Segmentation-not-working-why/m-p/2070832
https://community.powerbi.com/t5/Service/I-dont-get-the-revenue-segmented-by-the-dimension-why/m-p/2070833
