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.

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
4 years ago

MTrullàs 

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's avatar
MTrullàs
Icon for Helper III rankHelper III
4 years ago

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'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