Forum Discussion
Filter on the measure.
I need to create a measure that makes a calculation using the SUMX function but also has a filter, for example SUMX (table; max (year column); column1 * column2) and will also need to create a measur...
correct the error and the information is being displayed however when I do a filter annually whether in 2016, 2015 or 2014 values are blank
Sean
Community Champion
Community Championare you using DMEFG_Ano[Year] for the Slicer?
yes, to correct that what you recommend? I create a dimenssão calendar?
- Sean
Do you have any other filters/slicers ON at the same time?
EDIT:
If you want to create a Date Table look here (Link by Matt)
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
Yes, my reports have several filters
- Sean
Anonymous I tried these formulas with several Slicers and it works.