Forum Discussion
Wrong Total in SUMX
Make the relationship inactive. Use USERELATIONSHIP in your measure.
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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 DateI 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
- lbendlin
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
