Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, as you see in the pic, the Final Dax measure should be 3 but it is showing 0 in the final measure, What I am doing wrong?
Final Dax Measure is look like below:
Points_Earned_Goal =
VAR vGoalCode = SELECTEDVALUE('Metric Points Table'[Metric Code])
RETURN
SWITCH (
TRUE(),
vGoalCode = "M1", [Points_Earned_Goal_M1],
vGoalCode ="M2", [Points_Earned_Goal_M2],
vGoalCode ="M3", [Points_Earned_Goal_M3],
0
)
and [Points_Earned_Goal_M1] measure for Final Measure is below :
Points_Earned_Goal_M1 =
VAR vGoalName = SELECTEDVALUE('Metric Points Table'[Metric Definition])
VAR vMaxGoal = SELECTEDVALUE('Metric Points Table'[Max])
VAR vTargetGoal = SELECTEDVALUE('Metric Points Table'[Target])
VAR vMinGoal = SELECTEDVALUE('Metric Points Table'[Min])
VAR vBIOMPHA =
SWITCH (
TRUE(),
[BIOM] >= vMaxGoal, 3,
[BIOM] >= vTargetGoal && [BIOM] < vMaxGoal, 2,
[BIOM] >= vMinGoal && [BIOM] < vTargetGoal, 1,
[BIOM] >=0 && [BIOM] < vMinGoal , 0,
0
)
RETURN
COALESCE(vBIOM,0)
@NilR , Change this measure like
Points_Earned_Goal =
VAR vGoalCode = SELECTEDVALUE('Metric Points Table'[Metric Code])
RETURN
Sumx(values('Metric Points Table'[Metric Code]) ,
SWITCH (
TRUE(),
vGoalCode = "M1", [Points_Earned_Goal_M1],
vGoalCode ="M2", [Points_Earned_Goal_M2],
vGoalCode ="M3", [Points_Earned_Goal_M3],
0
) )
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 33 | |
| 29 | |
| 27 |
| User | Count |
|---|---|
| 133 | |
| 104 | |
| 61 | |
| 59 | |
| 55 |