Forum Discussion

amsrivastavaa's avatar
amsrivastavaa
Icon for Helper III rankHelper III
3 years ago

Reference Table from DAX

Hi Guys!!   My requirment is to create one Reference table using DAX in such a way that if there is any change in base table it will also get reflected in Reference table as well.   Lets say, I h...
Need Help
mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

Hi amsrivastavaa ,

try this maybe it works

 

Total_Amount = CALCULATE(SUM('Facts17'[Amount]),ALLSELECTED(Facts17))
 
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • amsrivastavaa's avatar
    amsrivastavaa
    Icon for Helper III rankHelper III
    3 years ago

    Hi mangaus1111 

     

    Thats giving me sum of all the records, i need sum based on Type and year for whatever data left after applying filter.

     

    Thanks

    Amit