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] ...
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
Super UserHaving difficulty understanding the model, could you post a picture of your model and the DAX formula?