Skip to main content
cancel
Showing results for 
Search instead 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

Reply
andrescaso
Resolver I
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 

FechaN° CarreraPosiciónDividendo
22-08-2018113,4
22-08-2018124,6
22-08-2018135,7
22-08-2018143,7
22-08-2018155,9
22-08-20182110
22-08-20182212
22-08-2018232,5
22-08-2018243,4
22-08-2018311,7
22-08-2018324,7
22-08-2018335,6
22-08-2018342,7
22-08-20183510,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
arvindsingh802
Super User
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])

 

image.png


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

View solution in original post

4 REPLIES 4
arvindsingh802
Super User
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])

 

image.png


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

Thanks Arvinds

 

The solution Works OK for me

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.

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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