Issue with DAX Calculation

[ItsMikeBelmont]

Hi guys!

First of all thanks for reading and helping.

Ok, let's suppose i have some price data like this

Owner	SKU	BRAND	DATE	PRICE	DESC	RETAIL
Company	74258323	A	########	1180	Prod A	WALMART
Competitor	14325325	B	########	3273	Prod B	WALMART
Competitor	1212434	C	########	644	Prod C	WALMART
Competitor	12145346	D	########	683	Prod D	WALMART
Company	74258323	A	########	2154	Prod A	WALLGREENS
Competitor	14325325	B	########	1945	Prod B	WALLGREENS
Competitor	1212434	C	########	733	Prod C	WALLGREENS
Competitor	12145346	D	########	577	Prod D	WALLGREENS
Company	74258323	A	########	1742	Prod A	TARGET
Competitor	14325325	B	########	1112	Prod B	TARGET
Competitor	1212434	C	########	589	Prod C	TARGET
Competitor	12145346	D	########	712	Prod D	TARGET

What i'm trying to calculate via DAX is a Price Index with this custom formula: (AVG Selling Price of my products / AVG Selling Price of my competence) * 100.

I have so far this two meassures:

ASP_Compete =
CALCULATE(
[ASP],
'Table'[Owner] = "Competitor"
)

ASP_Company =
CALCULATE(
[ASP],
'Table'[Owner] = "Company"
)

And a separate one for the price index wich is:

Price Index= DIVIDE(ASP_Comp, ASP_Compete) * 100

From my logic it should work fine, but when i drop into any vissual i got the error: "Error fetching data for this visual: An unexpected exception occurred"

Do you know if this is related to an issue of Power BI's version?

Thank u again for your answers.

Regards

[Rupak_bi · Accepted solution]

Hi @ItsMikeBelmont ,

This error comes when you have very large data.

However, the logic works fine with your sample data