Forum Discussion

Peter_23's avatar
Peter_23
Icon for Advocate V rankAdvocate V
2 months ago
Solved

left join dax

I have two tables store and clients; no relations between them. I must not have physical relationship, I prefer virtual. And the report have a many  slicers:  Year, region, country from clients. So ...
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • danextian's avatar
    danextian
    2 months ago

    Hi Peter_23​ 

    You can use TREATAS:CALCULATE( [Inventory Measure], TREATAS( VALUES(Slicer[Region]), Fact[Region] ) )

    If this doesn’t work, please provide a sample dataset along with the expected result based on that data. Please provide it as text/table format, not as an image, so I can clearly understand the intended outcome.

     

v-abhinavmu's avatar
v-abhinavmu
Icon for Community Support rankCommunity Support
2 months ago

Hi Peter_23​,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 


Thank you.