Segmentation not working, why?

[Anonymous]

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

[Anonymous]

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

[v-easonf-msft]

Hi, @Anonymous 

Could you please share a sample file further research?

Best Regards,
Community Support Team _ Eason

[Anonymous]

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]

Having difficulty understanding the model, could you post a picture of your model and the DAX formula? 

[AllisonKennedy]

@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 

[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