Custom measure problem: graph is right, tooltip value is wrong

[Anonymous]

[EDIT: solved. I deleted the measure, restarted Power BI and made a new measure with the same formula, no problems this time]

Hi all, 

I am having a problem with a simple measure I created. I have a table with data regarding how many people visit each page of a site, and I created a simple conversion measure: % of all people who complete the entire funnel. In other words, # of visits on the last page / # of visits on the first page. Here is the measure: 

CalcConversion = (sum('High Level Funnel'[Submit]))/(sum('High Level Funnel'[Welcome_Continue]))

Submit = visits to last page

Welcome_Continue = visits to first page 

The data table is also broken down by week and by product (I'll call them product A and product B). I would like a visual that shows overall conversion for both products, but can be filtered by a slicer to show product A and B individually as well. There are different amounts of product A and B visits each week so I can't take a simple average of conversion. So I made this measure, and I also calculated overall conversion in excel and imported that data separately to double check my measure. 

The problem: my measure looks right when I graph it, but the tooltips shows that conversion = 1 for every data point! There are also some weird formatting issues, with the y axis disappearing and the graph area leaving extra space below the x axis that I can't seem to adjust. I threw the values into a visual table to double check, and sure enough it's also showing as conversion = 1 for everything there as well. What's going on? How can I get the real values to appear in the tooltips, and is there a way to fix the formatting? 

Screenshot below: my new measure is graphed on the left, with my manual calculation on the right. As you can see the trend looks identical - appears that my measure is working correctly. But the table below shows the values are all equal to 1. 

Thanks for any help!

 

[v-shex-msft]

Hi @Anonymous,

Can you please provide some sample data or a pbix file to test? It is hard to reproduce your issue without data.

Regards, 

Xiaoxin Sheng

[WolfBiber]

Hey,

can you provide some more Information about you formula of the measure? And maybe a screenshot of you fields of you table?

greetings

[Anonymous]

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 

[WolfBiber]

if your posted fact table is like it is everything should work properly

[Anonymous · Accepted solution]

So does this look like a technical error to you? Anyone know how to troubleshoot this?