Finding running total based on legends used in the chart

[Anonymous]

HI Everyone,

I was trting to find running total for each category of sales.Its working fine if i select one legend from  the slicer.If all selected it is showing as percentage in grand total for each legend

How can i show Runninig total for each legend????

Below is the formula i have used in the calcualtion.

Running Total = CALCULATE(COUNT('OD Database'[Column]),

FILTER(

ALLSELECTED('OD Database'[Column]),

'OD Database'[Column]<=MAX('OD Database'[Column])

),VALUES('OD Database'[Mode_Toll]

))

Thanks

Yamuna

[v-juanli-msft]

Hi @Anonymous

Please read my screenshot below.

Part 1 is my data, 

Part 2 is what i assume your scenario is,

Part 3 is measures i created.

Measure 2 =
CALCULATE (
    COUNT ( Sheet1[column] ),
    FILTER (
        ALLEXCEPT ( Sheet1, Sheet1[cate] ),
        [column] <= MAX ( Sheet1[column] )
    )
)


Measure 3 = CALCULATE(COUNT(Sheet1[column]),ALLEXCEPT(Sheet1,Sheet1[cate]))

Measure 4 = [Measure 2]/[Measure 3]

Best Regards

Maggie

[Anonymous]

Thanks for your reply maggie,

I have attached sample workboook.I am trying to replicate same table data into line chart.

Line chart showing correct values when i select single mode from the slicer but when we are showing all modes....values are dividng to modes wise.

Any help on this.

https://drive.google.com/open?id=16bNozzPxDGZ15G5s1LDxzshxWSEXgpkQ

Thanks

Yamuna

[Anonymous]

Hi,

any one got solution for the above?

Thanks

Yamuna

[Anonymous]

Hi,

Can you please post some sample data and expected result screenshot please.

Regards,

Pavan Vanguri.

[Anonymous]

Hi,

Below is the screenshot : I have two modes using as legend and using as slicer.

Working fine when  i am using modes as slicer it is giving perfect running total of single mode...if i select all....running total is diving to all the modes.

Please help me on this.

Formula i have created:

Running Total = CALCULATE(COUNT('OD Database'[Column]),

FILTER(

ALLSELECTED('OD Database'[Column]),

'OD Database'[Column]<=MAX('OD Database'[Column])

)

)

I want to show running total of each mode even when all modes are selected.

Thanks in advance

Yamuna