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
Community ChampionAnonymous 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