cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Advocate I
Advocate I

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

View solution in original post

4 REPLIES 4
Advocate I
Advocate I

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

View solution in original post

Thanks Arvinds

 

The solution Works OK for me

Thanks Arvins

 

The solution Works OK for me

Resident Rockstar
Resident Rockstar

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors