Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.