TOTAL Count help

[danielnevitt]

Dear all,

I have the below expression:

Count({<[Late/OnTime]={`Late`},Trade_Create_monthyear={`Jan 2023`}>}[Trader Full Name])/Count(TOTAL <Trade_Create_monthyear={`Jan 2023`}>[Trader Full Name])

I'm trying to calculate the Count of Late where create date is Jan 2023 and then the TOTAL count of all trades where create date is Jan 2023. I require these calculations at a trader level.

Any help with the above is much appreciated.

Regards,
Daniel

[BrunPierre]

Count({$<[Late/OnTime]={'Late'}, Trade_Create_monthyear={'Jan 2023'}>} [Trader Full Name])
/
Count({$<Trade_Create_monthyear={'Jan 2023'}>} TOTAL [Trader Full Name])

[Marijn]

I think you could discard the TOTAL and just count all the 'Late' records divided by all the records in 'Jan 2023'?
Like this:

Count({<[Late/OnTime]={'Late'},Trade_Create_monthyear={'Jan 2023'}>}[Trader Full Name])
/
Count(<Trade_Create_monthyear={'Jan 2023'}>[Trader Full Name])

If you need it on a trader level and want to use the total function, I think you have to exclude the Trader from the total function. Like this:

Count({<[Late/OnTime]={'Late'},Trade_Create_monthyear={'Jan 2023'}>}[Trader Full Name])
/
Count(TOTAL <Trader Full Name> <Trade_Create_monthyear={'Jan 2023'}>[Trader Full Name])