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?