Forum Discussion
Helper IIIPercentile
Ok. That is different from what I had understood earlier. See it all at work in the attached file:
NewMeasure = VAR total_ = CALCULATE ( COUNT ( Table1[Estancia Fábrica] ), ALL ( Table1 ) ) VAR currentEst_ = SELECTEDVALUE ( Table1[Estancia Fábrica], total_ ) VAR cumul_ = CALCULATE ( COUNT ( Table1[Estancia Fábrica] ), Table1[Estancia Fábrica] <= currentEst_, ALL ( Table1 ) ) RETURN DIVIDE ( cumul_, total_ )Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Community ChampionSee if this measure works. It should be in a visual with HIFA[Estancia fábrica] on the rows, like the ones you show:
NewMeasure_ =
VAR total_ = CALCULATE ( SUM ( HIFA[Num_Coches] ), ALL ( HIFA ) )
VAR currentEst_ = SELECTEDVALUE ( HIFA[Estancia Fábrica] )
VAR cumul_ =
CALCULATE (
SUM ( HIFA[Num_Coches] ),
HIFA[Estancia Fábrica] <= currentEst_,
ALL ( HIFA )
)
RETURN
DIVIDE ( cumul_, total_ )
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Helper IIIThank you so much,
Now the measure works, I mean it gives me a result, but the result is not what I'm looking for.I don't know what the NewMeasure_is specifically
I the result that I expected is that the excel shows:
- AlB
hmm... I can't see what might be going wrong
Can you share the main table? Or an extract of it, with the expected result. So that I can run it on my side and see where the problem is coming from
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
- MTrullàs
Thank you... of course I do.
I'm new to the forum, so I have no idea how I can share it.Sorry, I look forward to that.
The significant column is "Estancia Fábrica"- MTrullàs
Sorry, now I try again,
Fgstnr Fábrica Campa Semana Mes Año Marca Estancia Fábrica 1 Mar Sch 14 Abril 2022 Sea 1 2 Mar Sch 14 Abril 2022 Sea 2 3 Mar Sch 14 Abril 2022 Sea 3 4 Mar Sch 14 Abril 2022 Sea 4 5 Mar Sch 14 Abril 2022 Sea 1 6 Mar Sch 14 Abril 2022 Sea 2 7 Mar Sch 14 Abril 2022 Sea 3 8 Mar Sch 14 Abril 2022 Sea 4 9 Mar Sch 14 Abril 2022 Sea 1 10 Mar Sch 14 Abril 2022 Sea 2 11 Mar Sch 14 Abril 2022 Sea 1 12 Mar Sch 14 Abril 2022 Sea 1 13 Mar Sch 14 Abril 2022 Sea 2 14 Mar Sch 14 Abril 2022 Sea 1 15 Mar Sch 14 Abril 2022 Sea 0 16 Mar Sch 14 Abril 2022 Sea 1 17 Mar Sch 14 Abril 2022 Sea 1 18 Mar Sch 14 Abril 2022 Sea 0 19 Mar Sch 14 Abril 2022 Sea 1 20 Mar Sch 14 Abril 2022 Sea 2 21 Mar Sch 14 Abril 2022 Sea 0 22 Mar Sch 14 Abril 2022 Sea 0 23 Mar Sch 14 Abril 2022 Sea 0