cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II

## Percentil with filter

Hello world!

Yesterday, with the help of @AlB I was able to solve a problem with the task Percentile.

Today I have a new challenge with the same topic. I have to calculte the same measure with the differents filters of the table.

So, I have that table with diferents columns, Fábrica, Campa, Semana, Mes, Año, Marca, with differents valuers. When I filter some valuer from the columns, the NewMesure_1 dosen't work, it appers the same valures that in general without filter.

Without filter the  NewMesure_1 works:

But, if I do a filter, it does not work because appears the same values.

The NewMesure_1 is:

``````NewMeasure_1 =
VAR total_ = CALCULATE ( COUNT ( Tabla[Estancia Fábrica] ), ALL ( Tabla ) )
VAR currentEst_ = SELECTEDVALUE ( Tabla[Estancia Fábrica], total_ )
VAR cumul_ =
CALCULATE (
COUNT ( Tabla[Estancia Fábrica] ),
Tabla[Estancia Fábrica] <= currentEst_,
ALL ( Tabla )
)
RETURN
DIVIDE ( cumul_, total_ )``````

And the example of the table is:

Fgstnr Fábrica Campa Semana Mes Año Marca Estancia Fábrica 1 Mar Sch 13 Abril 2022 Sea 1 2 Bar Sch 14 Abril 2022 Sea 2 3 Mar Sch 14 Abril 2022 Cup 3 4 Mar Sch 12 Abril 2022 Cup 4 5 Mar Sch 14 Abril 2022 Sea 1 6 Mar Sch 14 Abril 2022 Sea 2 7 Bar Sch 12 Abril 2022 Sea 3 8 Mar Sch 11 Abril 2022 Cup 4 9 Bar Sch 14 Abril 2022 Sea 1 10 Bar Sch 14 Abril 2022 Cup 2 11 Bar Sch 12 Abril 2022 Sea 1 12 Mar Sch 14 Abril 2022 Sea 1 13 Mar Sch 14 Abril 2022 Cup 2 14 Bar Sch 12 Abril 2022 Sea 1 15 Mar Sch 14 Abril 2022 Sea 0 16 Bar Sch 11 Abril 2022 Cup 1 17 Mar Sch 11 Abril 2022 Sea 1 18 Bar Sch 14 Abril 2022 Sea 0 19 Mar Sch 12 Abril 2022 Cup 1 20 Bar Sch 14 Abril 2022 Sea 2 21 Mar Sch 14 Abril 2022 Sea 0 22 Bar Sch 14 Abril 2022 Sea 0 23 Bar Sch 12 Abril 2022 Cup 0 24 Mar Sch 14 Abril 2022 Sea 1 25 Mar Sch 14 Abril 2022 Sea 1 26 Mar Sch 14 Abril 2022 Cup 1 27 Mar Sch 14 Abril 2022 Sea 2 28 Mar Sch 14 Abril 2022 Sea 2 29 Mar Sch 14 Abril 2022 Sea 2 30 Mar Sch 14 Abril 2022 Cup 2 31 Mar Sch 14 Abril 2022 Sea 2 32 Mar Sch 14 Abril 2022 Cup 1 33 Bar Sch 14 Abril 2022 Sea 1 34 Mar Sch 14 Abril 2022 Cup 1 35 Mar Sch 12 Abril 2022 Cup 1 36 Mar Sch 14 Abril 2022 Sea 1 37 Mar Sch 14 Abril 2022 Sea 1 38 Bar Sch 12 Abril 2022 Sea 1 39 Mar Sch 11 Abril 2022 Cup 1 40 Bar Sch 14 Abril 2022 Sea 2 41 Bar Sch 14 Abril 2022 Cup 1 42 Bar Sch 12 Abril 2022 Sea 1 43 Mar Sch 14 Abril 2022 Sea 1 44 Mar Sch 14 Abril 2022 Cup 1 45 Bar Sch 12 Abril 2022 Sea 1

Thhank you ver much!

1 ACCEPTED SOLUTION
Super User

It's the ALL(Tabla) that is overriding all the filters. Try this. If it doesn´t work, share the data in the same format as you did yesterday. Today's format is not good to copy

``````NewMeasure_2 =
VAR total_ = CALCULATE ( COUNT ( Tabla[Estancia Fábrica] ), ALL ( Tabla[Estancia Fábrica]) )
VAR currentEst_ = SELECTEDVALUE ( Tabla[Estancia Fábrica], total_ )
VAR cumul_ =
CALCULATE (
COUNT ( Tabla[Estancia Fábrica] ),
Tabla[Estancia Fábrica] <= currentEst_,
ALL ( Tabla[Estancia Fábrica] )
)
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.

2 REPLIES 2
Helper II

Thanks @AlB, this works just fine.

In the future, I wish I could help others like you.

Thanks!

Super User

It's the ALL(Tabla) that is overriding all the filters. Try this. If it doesn´t work, share the data in the same format as you did yesterday. Today's format is not good to copy

``````NewMeasure_2 =
VAR total_ = CALCULATE ( COUNT ( Tabla[Estancia Fábrica] ), ALL ( Tabla[Estancia Fábrica]) )
VAR currentEst_ = SELECTEDVALUE ( Tabla[Estancia Fábrica], total_ )
VAR cumul_ =
CALCULATE (
COUNT ( Tabla[Estancia Fábrica] ),
Tabla[Estancia Fábrica] <= currentEst_,
ALL ( Tabla[Estancia Fábrica] )
)
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.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors