Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Adding a filter from filter pane into a formula

I have the following measure (below).     If I apply a filter context (using the filter pane), the values in my measures get filtered down to the proper amount.    But note that in the 3rd table, wit...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Would you please inform us more detailed information(such as your expected output and your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.

 

As far as the measure you gave us, I suggest you change the Measure7 to:

 

Measure 7 =

VAR _date = MIN(Dates[Date])

VAR _lastDate = EOMONTH(_date,+0)+28

RETURN

CALCULATE(SUM(Flu_Snapshots[Actual Value]),FILTER(ALL(Dates[Date]), Dates[Date] = _lastDate))*-1

 

Please do mask sensitive data before uploading.

 

Thanks for your understanding and support.

 

Best Regards,

Dedmon Dai