topic Re: % Running Total by Max Qty of Filtered Criteria in DAX Commands and Tips

% Running Total by Max Qty of Filtered Criteria

Anonymous — Mon, 21 Nov 2022 09:39:25 GMT

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

daXtreme — Mon, 21 Nov 2022 10:06:08 GMT

FreemanZ — Mon, 21 Nov 2022 10:15:43 GMT

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 — Tue, 22 Nov 2022 09:54:58 GMT

Thank you very much ^^