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... 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"

 

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

MTrullàs 

You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

 

Be careful not to share confidential information

 

 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.