Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
Solved! Go to Solution.
Hi @ItsMikeBelmont ,
This error comes when you have very large data.
However, the logic works fine with your sample data
Hi @ItsMikeBelmont ,
This error comes when you have very large data.
However, the logic works fine with your sample data
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | 
| User | Count | 
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |