Forum Discussion
Wrong Total in SUMX
Make the relationship inactive. Use USERELATIONSHIP in your measure.
Thank you for your reply
Somehow, I managed to find a solution for the yesterday's problem. Now I am stuck with another one, please find below
I am trying to make a matrix with
Calendar[Date], Data[Ticker] and I want to add a measure to return the LAST PRICE for each ticker from Historical Prices table in all the Calendar[Date] rows. Also, it must return Blank if that ticker has no transaction in Transaction table in that Date
I managed to achieve the required result with helper table, please help to achieve the same result without the helper table and see the attached pbix file. https://drive.google.com/file/d/1pvIsF2q8_2tp9Wrj8sS6drFvkvS7VWj4/view?usp=sharing
My apologies if I could not explain the problem well, please feel free to ask if anything
Super User
the below is the expected result after modifying your DAX slightly. It works well if the 'Calendar' and 'Historical_Prices (fact)' tables are disconnected. Once the relationships are made, it does not work as expected.
I want to know how to make it work while the relationships are active, because I need the relationship for other calculations
- lbendlin
Make the relationship inactive. Use USERELATIONSHIP in your measure.