Forum Discussion
Custom measure problem: graph is right, tooltip value is wrong
So does this look like a technical error to you? Anyone know how to troubleshoot this?
Hey,
can you provide some more Information about you formula of the measure? And maybe a screenshot of you fields of you table?
greetings
Sure, I can't provide the exact data but here is a hypothetical example. Basically I'd want to have a measure that calculated Conversion by week, and can be filtered by Product.
| WeekStart | Product | Welcome_Continue | Submit | Converion by Week, Product |
| 11/5/17 | A | 2112 | 1282 | 60.70% |
| 11/12/17 | A | 2063 | 1242 | 60.20% |
| 11/19/17 | A | 1733 | 1064 | 61.40% |
| 11/26/17 | A | 1994 | 1166 | 58.48% |
| 12/3/17 | A | 1432 | 861 | 60.13% |
| 12/10/17 | A | 2025 | 1217 | 60.10% |
| 12/17/17 | A | 2000 | 1179 | 58.95% |
| 11/5/17 | B | 1245 | 786 | 63.13% |
| 11/12/17 | B | 1011 | 612 | 60.53% |
| 11/19/17 | B | 785 | 534 | 68.03% |
| 11/26/17 | B | 917 | 573 | 62.49% |
| 12/3/17 | B | 580 | 381 | 65.69% |
| 12/10/17 | B | 777 | 505 | 64.99% |
| 12/17/17 | B | 773 | 451 | 58.34% |
What other info do you need about the formula? I created the measure by following the tutorial here. I'm new to Power BI.
Here is the formula again:
CalcConversion = (sum('High Level Funnel'[Submit]))/(sum('High Level Funnel'[Welcome_Continue]))
In other words column D / column C
if your posted fact table is like it is everything should work properly
So does this look like a technical error to you? Anyone know how to troubleshoot this?