Error IVA

[Syndicate_Admin]

Hello, good morning everyone

I have an error when it comes to a report in PowerBi and basically it is that, when I try to put the VAT I get all these fields, I have tried with each one separately and all the ivas that come out are wrong. Someone would know how to solve it or what can I do to make the VAT appear correctly? Greetings

[PaulDBrown]

What the image displays is the outcome of the search function for tables/columns/measures. So if you search for "iva", the search will list all tables/columns/measures containing "iva".

so when you say that "all the ivas come out wrong", what do you mean exactly?

[Syndicate_Admin]

Hello, thanks for replying

Yes, it is indeed the result of the "VAT" search.
Currently I have in the report a column with the stipulated products and prices (attached capture) and I would like to add another column "VAT" and indicate the corresponding VAT of each product / price. Most of these columns come from the "VIS_PoweBi_AlbaranesVenta" field (second capture), but I do not see the option to add VAT.

And when I try to put some kind of VAT, example "%iva" I get the following (third capture). But the same thing happens with all the "iva"

In theory, the VAT would have to come out (4, 10 or 21) depending on the article.

[PaulDBrown]

It looks like you are adding fields from unrelated tables. Can you show how the model is set up, and in particular, the relevant tables to the visual?