Forum Discussion

ironboy0423's avatar
ironboy0423
Icon for Helper I rankHelper I
2 years ago

How can we sum values based on selected date range but with certain filters need to consider

My current formula aggregates everything when two identical ids are included in the date range selected:                     Total Amount = CALCULATE( SUM('Amounts'[Amount]), USE...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Keep the tables disconnected. Read about TREATAS, and then use it with the VALUES from your date slicer to filter your fact table.