Forum Discussion

amsrivastavaa's avatar
amsrivastavaa
Helper 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
Solution 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
Helper 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