Forum Discussion

andrescaso's avatar
andrescaso
Resolver I
7 years ago
Solved

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 ...
Need Help
  • arvindsingh802's avatar
    arvindsingh802
    7 years ago

    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])

     

arvindsingh802's avatar
arvindsingh802
Community Champion
7 years ago

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])

 

andrescaso's avatar
andrescaso
Resolver I
7 years ago

Thanks Arvinds

 

The solution Works OK for me