0

I have a model with DimCustomer, DimSegment and FactRevenue.

For most cases each customer is associated with a single segment.

There are a handful of Customers, that have two Segments… Therefore, in FactRevenue a few few cases of Customers have two Segments associated…

I want to “override” it and display 'current segment' only using FactRevenue (I don’t have a connection between DimCustomer and DimSegment)

Do I have any tools in DAX to achieve this?

Is it viable to have a mapped list of this exceptions and hardcode it somehow?

Improve this question
2
  • 1
    Your question isn't very clear. What is "It" that is being overridden, what type of output are you looking for a small data sample might help. Commented Aug 31, 2021 at 17:58
  • 1
    What do you want to override? A value in a FactRevenue? You can override data in a source, not in dax. You can add a calculated column in any table with a new value of current dream segment according to your wish. Anyway, reprex is your friend. Commented Aug 31, 2021 at 18:46
Related questions
2
PowerPivot - How to Filter Dimension to Get Value
0
Calculated column in DAX to show current BusinessArea
3
How to write a DAX measure based on both current row and slicer context?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.