topic Re: Medida incremental a partir de otra medida in DAX Commands and Tips

Medida incremental a partir de otra medida

Anonymous — Fri, 26 Aug 2022 07:10:18 GMT

Hola, tengo un problema con una medida acumulativa que no me acumula según requerimiento. He leído el foro y no hay nada similar. Mi problema es que necesito que sesiones agg, sea incremental

taa =

VAR vTableID =

SUMMARIZE( Sesiones, Sesiones[LApp], Sesiones[timestamp.1], Sesiones[session_Id],

"Rank", RANKX(ALL(Sesiones), Sesiones[N Sesiones])

)

VAR vTableWithMeasure =

ADDCOLUMNS ( vTableID, "Sesiones Agg", Sesiones[N Sesiones] )

return

vTableWithMeasure

Añado unos datos que tengo de ejemplo

Re: Medida incremental a partir de otra medida

Anonymous — Fri, 26 Aug 2022 07:16:18 GMT

En realidad busco ésta medida, pero necesito arreglar el paso previo con ese campo incremental para que funcione bien el percentil

Valor Percentil =

VAR vTableID =

SUMMARIZE( Sesiones, Sesiones[LApp], Sesiones[timestamp.1], Sesiones[session_Id],

"Rank", RANKX(ALL(Sesiones), Sesiones[N Sesiones])

)

VAR vTableWithMeasure =

ADDCOLUMNS ( vTableID, "Sesiones Agg", Sesiones[N Sesiones] )

VAR vResult =

PERCENTILEX.INC (

vTableWithMeasure,

[Sesiones AGG],

[Valor Percentiles]

)

RETURN

vResult

Re: Medida incremental a partir de otra medida

Anonymous — Tue, 30 Aug 2022 01:54:54 GMT

Hi Anonymous

Please provide sample data that completely covers the question, with expected output, thanks in advance!

How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Re: Medida incremental a partir de otra medida

Anonymous — Tue, 30 Aug 2022 07:21:52 GMT

I need measure Target. I have Date, LApp, Count Measure How can I have this measure Target?

Valor Percentil =

VAR vTableID =

RESUMEN ( Sesiones, Sesiones[LApp], Sesiones[Date],

"Measure Target" , RANKX ( TODAS (Sesiones), Sesiones[Count Measure])

)

VAR vResultado =

PERCENTILEX.INC (

vTableID ,

[Measure Target],

[Percentiles de valor]

)

DEVOLVER

vResultado

First, I need a temporal table that have Measure Target

Finally, I need to take the percentil X to be able to report this KPI

But first, I think I need to obtain the Target Measure before to calculate the percentil

Thx