Division between two measures always results in "0"

[Syndicate_Admin]

Good to tod@s,

I am trying to divide two measures to show a variance of one with respect to the other (measure 1/measure2-1), but when I carry it out it comes out that the result always 0. I have tried with divide and with division(/) itself and I get the same result.

This last image corresponds to the same calculation in Excel that does come out correct. The above are the different measures that are used in the calculation.

Thank you very much in advance.

[amitchandak]

@Syndicate_Admin , Can you also use divide in Personal Pick and General Pick.

Also, are these two marked as % column?

Make sure varizana pick is marked as % column

if did not help

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Syndicate_Admin]

Thank you for the prompt response.

The personal pick and general pick measurement data are integer numbers, Variance Pick is in percentage format (%). The other divisions work well.

This is the table of measures as a whole (Measures stacked next to and on top of others, very simple ;))

And this is one of the tables where you use the data from.

Thanks again.