running % not working

[PowerBIBeginer]

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])))

[Ashish_Mathur]

Hi,

Share some data, describe the question and show the expected result.

[PowerBIBeginer]

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]

@Ashish_Mathur , Hi Sir, have posted few screenshot's.. Will it help you to understand my query please.. please let me know

[Ashish_Mathur]

Hi,

Screenshots do not help.  Share the download link of the PBI file, explain the question and show the expected result.

[PowerBIBeginer]

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.. 

[amitchandak]

@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