Need help writing DAX measure

[TaylorOsenni]

I have a dimension table that has an ABC analysis at 3 different aggregation levels. 

1)Product Code/Market - example "United States"

2)Product Code/ Region - example "Americas"

3)Product Code/ Global - just product code

Yeah one has its own ABC analysis assigned. Does anyone know of a way to make this possible? I have a Dimension "Region" table that has market and region. If I select one specific market, I want to see the abc analysis at market level. If I select a region I want it to show the ABC at region level, and if nothing selected then show the global?

Please let me know if this is possible. Thanks!

@Greg decker

[v-pnaroju-msft]

Hi TaylorOsenni,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi TaylorOsenni,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi TaylorOsenni,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @maruthisp, for your response.

Hi @TaylorOsenni,

Thank you for your inquiry on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who face similar queries.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[maruthisp]

Hi TaylorOsenni,

Try below DAX expression:
ABC_Contextual =
SWITCH(
TRUE(),
ISFILTERED('Region'[Market]), MAX(DimProductABC[ABC_Market]),
ISFILTERED('Region'[Region]), MAX(DimProductABC[ABC_Region]),
MAX(DimProductABC[ABC_Global])
)

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated — thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X