% Running Total by Max Qty of Filtered Criteria

[Anonymous]

Hi All, I'm new here

I really need your help to create sql syntax in power BI for Running Total %

I only able to create in Pivot Excel (below pic) but found difficulty to create in Power BI

Below is part of my data 

Plant	Date	DT Description	DT MT
LTS	1-Jun-22	Low feed on DSSE	27.70
LTS	2-Jun-22	Mixed bed regen	34.00
LTS	3-Jun-22	Low feed on DSSE	38.70
LTS	4-Jun-22	Low feed on DSSE	17.10
LTS	5-Jun-22	Centrifuge issue	20.26
LTS	6-Jun-22	Centrifuge issue	12.00
LTS	7-Jun-22	Outlet crystallizer blocking	7.60
LTS	8-Jun-22		2.74
LTS	9-Jun-22	Actuator valve on autoclave trouble	4.28
LTS	16-Jun-22	Mixed bed regen	12.40

Really appreciate for the help

Thanks and Regards,

Abimanyu

[FreemanZ · Accepted solution]

Try to create a measure with the code below:

Running Total% =

VAR _CurrentDT = MAX(TableName[DT Description])

VAR _TotalAmt =

CALCULATE(

    SUM(TableName[DT MT]),

    ALL(TableName)

)

VAR _CurrentRT =

CALCULATE(

    SUM(TableName[DT MT]),

     TableName[DT Description]<=_CurrentDT

)

VAR _ratio = FORMAT( DIVIDE (_CurrentRT, _TotalAmt), "0%")

RETURN

_ratio

I tried and it works like this:

[Anonymous]

Thank you very much ^^

[daXtreme]

Please read this before you start posting: How to Get Your Question Answered Quickly - Microsoft Power BI Community