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

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