Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

power bi

First i want to remove week 0 from the table and then   need to find the Cummulative Average of Cummulative Total Column  Cummulative Total Column -- Measure (not a column)   Output to be l...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi Anonymous ,

     

    Try to do the following:

    Cumulative Average = 
VAR WEEKNUMBER =
    MAX ( TableTotal[Week] )
VAR temp =
    SUMMARIZE (
        ALL ( TableTotal ),
        TableTotal[Week],
        "CumulativeTotal", [Cumulative Total]
    )
VAR Result =
    FILTER ( temp, TableTotal[Week] <= WEEKNUMBER && TableTotal[Week] > 0 )
RETURN
    AVERAGEX ( Result, [CumulativeTotal] )

     

     

MFelix's avatar
MFelix
Super User
4 years ago

Hi Anonymous ,

 

Try to do the following:

Cumulative Average = 
VAR WEEKNUMBER =
    MAX ( TableTotal[Week] )
VAR temp =
    SUMMARIZE (
        ALL ( TableTotal ),
        TableTotal[Week],
        "CumulativeTotal", [Cumulative Total]
    )
VAR Result =
    FILTER ( temp, TableTotal[Week] <= WEEKNUMBER && TableTotal[Week] > 0 )
RETURN
    AVERAGEX ( Result, [CumulativeTotal] )

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

OMG!! YES ITS WORKING!!! SMARTEST Solution. I worked two days on this.. I REALLY DONT KNOW HOW TO THANK YOU!!!. OH MY LORD!!!  Is there any way i can connect with u on LINKEDIN pls?? THANKSSSS A TON 😁