Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago
Consumption Warehouse 2 = calculate (sum (Facts [Vl_ConsumoAlmox]) - sum (Facts [Vl_EstornoAlmox]), FILTER (DMEGF_Ano; DMEGF_Ano [Year] = (MAX (DMEGF_Ano [Year]) - 1)))
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous

                                                                                                           2016  - ( 2016 -  1) => 1 

FILTER (DMEGF_Ano; DMEGF_Ano [Year] = MAX (DMEGF_Ano [Year]) - (MAX (DMEGF_Ano [Year]) - 1)))

 

delete the underlined part

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    are you using DMEFG_Ano[Year] for the Slicer?

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Sean Greg_Deckler

     

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Sean

    yes, to correct that what you recommend? I create a dimenssão calendar?

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Sean

    Yes, my reports have several filters

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Anonymous I tried these formulas with several Slicers and it works.