cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## Create a Meassure

Hi guys, i´m a new user in power BI, and i need help to make a new measure, please,

this is my problem:

i have this table

 Fecha N° Carrera Posición Dividendo 22-08-2018 1 1 3,4 22-08-2018 1 2 4,6 22-08-2018 1 3 5,7 22-08-2018 1 4 3,7 22-08-2018 1 5 5,9 22-08-2018 2 1 10 22-08-2018 2 2 12 22-08-2018 2 3 2,5 22-08-2018 2 4 3,4 22-08-2018 3 1 1,7 22-08-2018 3 2 4,7 22-08-2018 3 3 5,6 22-08-2018 3 4 2,7 22-08-2018 3 5 10,8

and the measure is for count how many times in the same "Fecha" and in the same "N° Carrera" for "Posición" = 1, the parameter "Dividendo" is the minimum value, for this example is 2, the dividendo 3,4 and 1,7 of N° Carrera 1 and 3

Regards

1 ACCEPTED SOLUTION
Super User

You need column if you also have to see where are the minimum values i.e. 3.4 and 1.7
and then you can create a measure to have the count as well.

Check = IF(AND(CALCULATE(MIN('Table'[Dividendo]),FILTER('Table','Table'[Fecha]=EARLIER('Table'[Fecha])),FILTER('Table','Table'[N° Carrera]=EARLIER('Table'[N° Carrera]))) = 'Table'[Dividendo],'Table'[Posición]=1), 1, 0)

and for Measure = SUM('Table'[Check])

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!
4 REPLIES 4
Super User

You need column if you also have to see where are the minimum values i.e. 3.4 and 1.7
and then you can create a measure to have the count as well.

Check = IF(AND(CALCULATE(MIN('Table'[Dividendo]),FILTER('Table','Table'[Fecha]=EARLIER('Table'[Fecha])),FILTER('Table','Table'[N° Carrera]=EARLIER('Table'[N° Carrera]))) = 'Table'[Dividendo],'Table'[Posición]=1), 1, 0)

and for Measure = SUM('Table'[Check])

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!
Resolver I

Thanks Arvinds

The solution Works OK for me

Resolver I

Thanks Arvins

The solution Works OK for me

Anonymous
Not applicable

Can you post the expected output as well in a table format as shown above? That will help.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors