Forum Discussion

ErnestoSanchez's avatar
ErnestoSanchez
Frequent Visitor
6 years ago

Average ov Averages

Hi everybody, Thanks for take your time to help me.   I have a two clustered column charts In the first one I show absolut values (80,  54, 198, etc.) In the second one I show relatives values r...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ErnestoSanchez,

You can try to use the following measure formulas if it meets your requirement:

Graduados% based on selection = 
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( Consolidado ),
        [SEXO],
        [PAIS],
        [FINANCIADOR],
        [SOCIO],
        [SEDE],
        [NÚMERO DE PROMOCIÓN],
        "Percent", DIVIDE (
            CALCULATE (
                SUM ( Consolidado[INSCRITOS] ),
                Consolidado[INDICADORES] = "Jóvenes inscritos que se graduan"
            ),
            CALCULATE (
                SUM ( Consolidado[soTOTAL] ),
                Consolidado[INDICADORES] = "Jóvenes inscritos que se graduan"
            ),
            BLANK ()
        )
    )
RETURN
    AVERAGEX ( summary, [Percent] )

Regards,

Xiaoxin Sheng

ErnestoSanchez's avatar
ErnestoSanchez
Frequent Visitor
6 years ago

Thanks for your effor Anonymous 

Taking your solution, every category (sexo, pais, financiador, socio, sede, numero) works fine if in the measure there are only them.

When I put all together, as you have in your solution, the result start to be wrong.

Thanks again.