Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |