Display current segmentation instead of the historical?

[ovonel]

I currently have a visual where I display segment associated with revenue.

I want to override it and display current segment. The only way to achieve it is if I go like this from    revenue -> customer -> customer segmentation.   In sql it would be:

select dcs.Segment

from FactRevenue fr

join DimCustomer_Current dc on fr.Key_Customer = dc.Key_Customer

join DimCustomerSegmentation_Current dcs on dc.CustomerNo = dcs.CustomerNo

What is the best way to achieve this?

Shall I create a relationship in the model for customer and customer segmentation and then do a calculated column??

Or

Is using dax the best solution for this?

[v-yalanwu-msft]

Hi, @ovonel ;

Is the above answer helpful to you? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @ovonel ;

You could create a new table by dax . According to information your  provided ,  please try:

NewTable =
SUMMARIZE (
    FILTER (
        'FactRevenue fr',
        [Key_Customer]  IN 
        SUMMARIZE (FILTER (
                    'DimCustomer_Current',
                    [CustomerNo] IN VALUES ( 'DimCustomerSegmentation_Current'[CustomerNo] )),[Key_Customer])),
    [Key_Customer])

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.