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
