Forum Discussion
MTrullàs
Helper III
4 years agoPercentile
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...
- 4 years ago
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
Helper III
4 years agoThank 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
Helper III
4 years agoSorry, 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 |
- MTrullàs4 years ago
Helper III
More info,... thank you so much for your time.
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 Etiquetas de fila Cuenta de Estancia Fábrica objective 3 Mar Sch 14 Abril 2022 Sea 3 0 5 22% 4 Mar Sch 14 Abril 2022 Sea 4 1 9 61% 5 Mar Sch 14 Abril 2022 Sea 1 2 5 83% 6 Mar Sch 14 Abril 2022 Sea 2 3 2 91% 7 Mar Sch 14 Abril 2022 Sea 3 4 2 100% 8 Mar Sch 14 Abril 2022 Sea 4 Total general 23 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