Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Helper V
3 years ago

running % not working

Hi All,

 

One issue I'm struglling with. Below is running % dax.. My column chart values changing but this running % not changing. Can anyone please help to understand where could be the issue please

 

Running Total% = 
DIVIDE(
CALCULATE(
COUNT('Report'[ID]),
FILTER(ALLEXCEPT('Report','Report'[Client Region],'Report'[Location],'Report'[Request Type],'Report'[Month]),
'Report'[Rank]<=MAX('Report'[Rank])))
,
CALCULATE(
COUNT('Report'[ID]),
ALLEXCEPT('Report','Report'[Client Region],'Report'[Location],'Report'[Request Type],'Report'[Month])))

 

 

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    PowerBIBeginer , If you have date prefer to use that or use sortable year month in measure like this

     

    Cumm Sales %= Divide( CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date]))),ALCULATE(SUM(Sales[Sales Amount]),all())

    Cumm Sales %= Divide(CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date]))),(CALCULATE(SUM(Sales[Sales Amount]),allselected())

     

    for numerator, you can also consider the window function

    Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

    • PowerBIBeginer's avatar
      PowerBIBeginer
      Helper V
      3 years ago

      Hi Amit / Ashish, Thank You both for your response. I'm sharing few screenshot, may be from that you will get what I'm trying to say..

       

      • PowerBIBeginer's avatar
        PowerBIBeginer
        Helper V
        3 years ago

        In the screenshot you can look clearly that I'm changing month, columns got change but no change on line graph i.e. running total %. They are contstant.. and dont understand what to do with this..