Forum Discussion

MTrullàs's avatar
MTrullàs
Icon for Helper III rankHelper III
4 years ago
Solved

Percentile

Hi everybody!   I want to calculate column D in this example with DAX.     I try to do it with this code, but I have some mistakes in the results.     Percentil Fábrica = VAR Totalco...
  • AlB's avatar
    AlB
    4 years ago

    MTrullàs 

    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.

     

MTrullàs's avatar
MTrullàs
Icon for Helper III rankHelper III
4 years ago

Sorry, now I try again,

 

FgstnrFábricaCampaSemanaMesAñoMarcaEstancia Fábrica
1MarSch14Abril2022Sea1
2MarSch14Abril2022Sea2
3MarSch14Abril2022Sea3
4MarSch14Abril2022Sea4
5MarSch14Abril2022Sea1
6MarSch14Abril2022Sea2
7MarSch14Abril2022Sea3
8MarSch14Abril2022Sea4
9MarSch14Abril2022Sea1
10MarSch14Abril2022Sea2
11MarSch14Abril2022Sea1
12MarSch14Abril2022Sea1
13MarSch14Abril2022Sea2
14MarSch14Abril2022Sea1
15MarSch14Abril2022Sea0
16MarSch14Abril2022Sea1
17MarSch14Abril2022Sea1
18MarSch14Abril2022Sea0
19MarSch14Abril2022Sea1
20MarSch14Abril2022Sea2
21MarSch14Abril2022Sea0
22MarSch14Abril2022Sea0
23MarSch14Abril2022Sea0
MTrullàs's avatar
MTrullàs
Icon for Helper III rankHelper III
4 years ago

More info,... thank you so much for your time.

 

FgstnrFábricaCampaSemanaMesAñoMarcaEstancia Fábrica     
1MarSch14Abril2022Sea1     
2MarSch14Abril2022Sea2  Etiquetas de filaCuenta de Estancia Fábricaobjective
3MarSch14Abril2022Sea3  0522%
4MarSch14Abril2022Sea4  1961%
5MarSch14Abril2022Sea1  2583%
6MarSch14Abril2022Sea2  3291%
7MarSch14Abril2022Sea3  42100%
8MarSch14Abril2022Sea4  Total general23 
9MarSch14Abril2022Sea1     
10MarSch14Abril2022Sea2     
11MarSch14Abril2022Sea1     
12MarSch14Abril2022Sea1     
13MarSch14Abril2022Sea2     
14MarSch14Abril2022Sea1     
15MarSch14Abril2022Sea0     
16MarSch14Abril2022Sea1     
17MarSch14Abril2022Sea1     
18MarSch14Abril2022Sea0     
19MarSch14Abril2022Sea1     
20MarSch14Abril2022Sea2     
21MarSch14Abril2022Sea0     
22MarSch14Abril2022Sea0     
23MarSch14Abril2022Sea0