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 create a measure with variable table to fix the calculated result of the first aggregated calculate, then you can use iterator function on this table to apply the second aggregated mode.

Sample:

measure =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( Table ),
        [Category],
        "AVG", AVERAGE ( Table[Amount] )
    )
RETURN
    AVERAGEX ( summary, [AVG] )

Regards,

Xiaoxin Sheng

ErnestoSanchez's avatar
ErnestoSanchez
Frequent Visitor
6 years ago

Thanks Anonymous ,

I have been trying to figure out what do you mean with your soluction,

But I couldn't concretize it in my .pbix file to get the correct results.

 

May I ask you to give me more details.

 

Thanks..

  • 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.