Max Data Error

[Syndicate_Admin]

Good afternoon, I wanted to ask you for help with a MAX function, I have a base in which I have Nro of installments for example from 1 to 40 or 1 to 24, the maximum number of installments that each credit has, when using the CALCULATE to be able to filter by IDCREDITO returns the same number of installments not the maximum of the credit

CuotasSum = CALCULATE(MAX(DATASET_CAIDA_PRESELECCION[NROCUOTA]),DATASET_CAIDA_PRESELECCION[ID_CREDITO])

Thank you very much.-

[Anonymous · Accepted solution]

Hi @pcarrizo ,

Do you want to group by ID_CREDITO and return the maximum value?

Try this calculated column

CuotasSum =
CALCULATE (
    MAX ( 'DATASET_CAIDA_PRESELECCION'[NROCUOTA] ),
    ALLEXCEPT ( DATASET_CAIDA_PRESELECCION, DATASET_CAIDA_PRESELECCION[ID_CREDITO] )
)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.