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
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?
