Forum Discussion

Atifz's avatar
Atifz
Frequent Visitor
6 years ago

Reverse Cumulative measure

Hi all,   I am trying to create a reverse cumulative measure and I am having difficulty when there are blanks in my data.    Using this calculated measure, I get the table below, but where there ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Check

reverse cumm = 
var _cumm =CALCULATE (
sum('Registrations'[Registrations]),
FILTER(
ALL( 'Registrations'[DaysDiff]),
                'Registrations'[DaysDiff] <=MAXX(all('Registrations'),'Registrations'[DaysDiff])))
var _ear =CALCULATE (
sum('Registrations'[Registrations]),
FILTER(
ALL( 'Registrations'[DaysDiff]),
                'Registrations'[DaysDiff] <=MAX('Registrations'[DaysDiff])-1))
return
_cumm -_ear

 

There is minor diff, please check

Solution link :https://www.dropbox.com/s/dvrkkmupwk4r7fz/ReverseCumm.pbix?dl=0

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

Atifz's avatar
Atifz
Frequent Visitor
6 years ago

hi amitchandak,

 

I get an error at this part in in both of the rows.

sum('Registrations'[Registrations])

 

If it helps, [Registrations] is a measure made from CountA([BidderID]), where BidderID is a string.

 

Thanks

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Try using CountA([BidderID]) or [Registrations], in place of Registrations[Registrations]

    • Atifz's avatar
      Atifz
      Frequent Visitor
      6 years ago

      hi amitchandak 

       

      It doesn't let me put the CountA in the Sum, but if I replace the whole row with it, I get the same results as the beginning, with the rows with blank showing 460

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        Share sample of data in your original data format