Forum Discussion

MohamedSalih_12's avatar
MohamedSalih_12
Frequent Visitor
1 year ago
Solved

Wrong Total in SUMX

I have two fact tables  1. Historic Stock prices downloaded from Google sheets with 3 Columns Date, Ticker, Unit Price 2. Stock Buy transactions table with 4 Columns Date, Ticker, Quantity, Unit Pr...
  • lbendlin's avatar
    lbendlin
    1 year ago

    Make the relationship inactive. Use USERELATIONSHIP in your measure.

MohamedSalih_12's avatar
MohamedSalih_12
Frequent Visitor
1 year ago

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's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Make the relationship inactive. Use USERELATIONSHIP in your measure.