Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning everyone,
I get this database :
Semaine | Lot | Valeur |
42 | 2644 | 80 |
42 | 2645 | 80 |
42 | 3001 | 75 |
42 | 3003 | 72 |
42 | 3201 | 75 |
42 | 3201 | 78 |
42 | 3203 | 70 |
42 | 5032 | 75 |
42 | 6206 | 70 |
43 | 125 | 70 |
43 | 2643 | 78 |
43 | 2644 | 78 |
43 | 2645 | 78 |
43 | 3001 | 80 |
43 | 3002 | 80 |
43 | 3003 | 70 |
43 | 3201 | 78 |
43 | 3201 | 80 |
43 | 3202 | 80 |
43 | 5032 | 80 |
43 | 6202 | 70 |
43 | 6207 | 70 |
43 | R00 | 70 |
I would like to calculate the percentage of Lot with a result of Valeur less than 72 or egal. I would like to do this calculation per week.
Do you know how to do to make this calculation please ?
Thank you for your help.
Jonathan
Solved! Go to Solution.
Hi, try with this Dax Code.
Percent less than 72 or equal = DIVIDE ( CALCULATE ( COUNT ( Table1[CodRuta] ), Table1[ALC] <= 72 ), COUNT ( Table1[CodRuta] ) )
Let me know if works
Hi i needDax to create a pie chart
I have 50 students and 4 subjects, If one students pass in 4 sbujects then it should be Pass /if one student fail in 1 subject they consider to fail will you help me regarding this
UP
Hi, try with this Dax Code.
Percent less than 72 or equal = DIVIDE ( CALCULATE ( COUNT ( Table1[CodRuta] ), Table1[ALC] <= 72 ), COUNT ( Table1[CodRuta] ) )
Let me know if works
Thank you this calculation works.
Have a good day.
Jonathan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |