the result divide of two measure is not as expected

[yudhamm]

hai can i get help,
i want to make divide of two measure but the result not as expected,
First Measure :

STP EX EKIT = CALCULATE(

    COUNT(STP[CONTRACT_NO]),

    STP[CHANNEL] IN {"AGENCY","BANCASS"},

    STP[STP] = "STP",

    STP[YEAR ISSUED] = 2025)

And the result :

the secound Measure is :

SUBMISSION ALL = CALCULATE(

    COUNT(STP[CONTRACT_NO]),

    STP[CHANNEL] in {"AGENCY","BANCASS"},

    STP[YEAR SUBMISSION] = 2025)

And the result :

but when i want divide STP EX EKIT, SUBMISSION ALL(STP EX EKIT/SUBMISSION ALL), the result is not expected,
in january i want the result is 5615/13500 = 41,6%. but i get result

with this dax divide

STP EX EKIT ON ALL SUBMISSION = DIVIDE([STP EX EKIT],STP[SUBMISSION ALL]). i hope i can get solusion

[sanalytics · Accepted solution]

Hello @yudhamm 
Can you change your code little bit. and see if it works or not..

STP EX EKIT = 
CALCULATE(
    COUNT(STP[CONTRACT_NO]),
    STP[CHANNEL] IN {"AGENCY", "BANCASS"},
    STP[STP] = "STP",
    STP[YEAR ISSUED] = 2025,
    VALUES(STP[MONTH ISSUED])
)

SUBMISSION ALL = 
CALCULATE(
    COUNT(STP[CONTRACT_NO]),
    STP[CHANNEL] IN {"AGENCY", "BANCASS"},
    STP[YEAR SUBMISSION] = 2025,
    VALUES(STP[MONTH SUBMISSION])
)

and use the Divide function for Percentage

DIVIDE(
    [STP EX EKIT],
    [SUBMISSION ALL],
    0
)

 let me know if it works or not.. if not, i reuqest you to provide your data model along with some dummy data.

Regards

sanalytics

[yudhamm]

Thank you, for your solution