Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear all
I need assistance with a calculation involving goal and completed data, both of which are measurements.
I want to measure actual completions and incompletions (column D and E) for each program based on the following criteria:
If the completed number exceeds the goal number, only the goal number should be counted.
For example, in a particular case, the completion is calculated as 42, while the incompletion stands at 8.
Your guidance would be greatly appreciated.
Looking forward to your insights.Thanks
Solved! Go to Solution.
Hi @WWC2024 ,
Thank you for reaching out to us!
I tried to recreate it with my sampe data.Used below measures:
Hi @WWC2024 ,
Thank you for reaching out to us!
I tried to recreate it with my sampe data.Used below measures:
Dear Friend
total # in completions and incompletions are incorrect.
Since Goal and completed are measure, so I have tried the following dax and it works and wold like to share with you all.
1) get the goal exected adjust =
solve the "total row " is very interesting question. Believe many are facing the same problems.
Completion =
Sumx(
Values( table[program]),
Var goal =
Calculate( sum( table[goal]))
Var complete =
Calculate( sum( table[complete]))
Return
If( complete > goal, goal, complete)
Incomplete=
Completion =
Sumx(
Values( table[program]),
Var goal =
Calculate( sum( table[goal]))
Var completion =
[completion]
Return
goal - completion
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |