Forum Discussion

ankit48365's avatar
ankit48365
Regular Visitor
4 years ago
Solved

DAX Query for Running Total

Hi,   I created a simple view of 3 columns, (city name, date of completion for that city, a flag as 1 for filtering cities with completion date) like below now i created a measure (like a ne...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    Try This

    Measure = CALCULATE(SUM(MYVIEW[FLAG]), FILTER(ALL(MYVIEW),MYVIEW[COMPLETIONDATE]<= MAX(MYVIEW[COMPLETIONDATE])))
FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

Try This

Measure = CALCULATE(SUM(MYVIEW[FLAG]), FILTER(ALL(MYVIEW),MYVIEW[COMPLETIONDATE]<= MAX(MYVIEW[COMPLETIONDATE])))
ankit48365's avatar
ankit48365
Regular Visitor
4 years ago

Thanks Farhan, That resolved it 🙂 

 

so for my future understanding, we shuld apple to undo the filter on all columns, rather then jus one column ....