Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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])
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])
Thanks Arvinds
The solution Works OK for me
Thanks Arvins
The solution Works OK for me
Can you post the expected output as well in a table format as shown above? That will help.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |