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.
Hi,
I created multiple measures and need to sum specific ones multipied by 100 to get % Complete to Date for AW Field, AW Management, and B/C. Then put the sum into a card.
I will then have to create another table with all measures shown below PLUS 4 other measures to get % Complete to Date Project As a Whole.
PBIX file below for reference.
Solved! Go to Solution.
you can try this
%Complete to Date = ([AW Field Measure]+[AW Management Measure]+[B/C Measure])*100
Proud to be a Super User!
Hi @PabloGiraldo ,
If you just want to simply sum the vaules of measures you could you could directly use "+", like:
(measure1+measure2+measure3+...)*100
If I misunderstand your meaning, please show more details.
Best Regards,
Jay
Hi @PabloGiraldo ,
If you just want to simply sum the vaules of measures you could you could directly use "+", like:
(measure1+measure2+measure3+...)*100
If I misunderstand your meaning, please show more details.
Best Regards,
Jay
you can try this
%Complete to Date = ([AW Field Measure]+[AW Management Measure]+[B/C Measure])*100
Proud to be a Super User!
@PabloGiraldo , I create a measure
Measure = ([AW Field Measure]+ [AW Management Measure] + [Berkel Measure])*100
Added that to Table and gor value 4.15, not sure that is correct.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |