Earn 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 |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |