How to acumulate values of measures.

[Rifilho19]

Greetings

I'm trying to make a measure to roll up data, but my values ​​don't roll up when I use the measure instead of a column,

How to solve this problem?

Thank you very much in advance!

[amitchandak]

@Rifilho19 , is Period_omes is coming from Spoint_priods? If not take Period_omes  from Spoint_priods or put the filter on the table having Period_omes 

[Rifilho19]

Thank you for te reply, @amitchandak 

Yes, I´m using the periods from sharepoint.
but the measurement doesn't work as expected
I think it's because I want to accumulate data from a measure and not a column.
is my understanding correct?

If i´m correct, how do you sugest to solve this probleam?


Thank you, so much

[v-deddai1-msft]

Hi @Rifilho19 ,

The accumlated measure will work for measure also. Did you have a dim_date table in your data model? If not , please create one by:

DIM_Date = ADDCOLUMNS(CALENDAR(MIN(YourFactTable[Date]),MAX(YourFactTable[Date])),"MONTHYEAR",FORMAT([Date],"mmm-yy"))

Connect it with your fact table by [MONTHYEAR].

Then you can use the following measure(using the MONTHYEAR column from the DIM_Date table as rows in your matrix visual 😞

Acumulated measure = CALCULATE([Your measure],FILTER(ALL(DIM_Date),DIM_Date[Date]<=MAX(DIM_Date[Date])))

If it doesn't work, please show us your sample pbix instead of screenshot.

Thank you for your support and understanding.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Rifilho19]

Hi @v-deddai1-msft !,

Thank you for your support.

I´ve a date table in my PBI, it name is "Periodos".

Unfortunately I don´t have permission to share my pbix... 😕

 I don´t know what I do now.. 
If  somebody knows my probleam, please contact me.
Thank you very much!!

[v-deddai1-msft]

Hi @Rifilho19 ,

There are many causes can lead to the issue. Some filter context outside. Without your sample pbix , it is difficult for us to support you. Maybe you can create some fake data that can reproduce the issue. Then you we can help you accurately.

Best Regards,

Dedmon Dai