Check my solution

[8CL]

https://1drv.ms/u/s!AumL6_LtkgXdg9wD4jwa3oDBaqt5aA?e=lq7Ttg 

In the "pbix" file above I solved the following questions:

1-Obtain the sales amount of Bicilink by applying the 13% discount in May of the category-segment and the year indicated:
Category-Segment Mountain bike-Cross Country Year 2018
Total sales amount for that category-segment in that year
Answer: 60.700.645,00 (page 4)

2-Obtain the % of bicilink's annual losses if the 13% discount is applied in May for the category-segment and the year indicated:
Category-Segment Urban bike-Electric
Year 2019
Answer:13,0% (page 5)

I´d like to know if the answers for the above question are correct based on my solution and if not show me the correction.

Thank you!

[Anonymous · Accepted solution]

Hi @8CL 

(1)As you said , the first value you calculate is to return the 87% of the total for ‘VentasTotales’[Importe] filtered by Categoria -Mountain bike , segment- Cross Country and year-2018 .So I extarct the field [Importe],[ProductoID],[Categoria],[Fecha] from table ‘VentasTotales’，then add three slicers to filter value ,the total for Importe is 69770856.33 . Multiply this value by 0.87, and the result is the same as yours .

(2) Regarding your second question, I don’t understand it very well. ImporteDescuento=Import * 0.87, then subtract ImporteDescuento from Import and divide by Import. The result is 13%. What is your logic ?

I made some changes in your pbix file , and I have attached it ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.