% Calculation is not working

Hi RanjanThammaiah ,

If I understand correctly, the relationship between your two tables is ‘Many - to - One’.

I make a sample to explain your question. If you need, you can download it.

There is a ‘Many - to - One’ relationship between ‘Table 1’ and ‘Table 2’ based on ‘Product’. The measures are as follows:

sum of Sales = SUM('Table 1'[Sales])

sum of Stock = SUM('Table 2'[Stock])

Measure = CALCULATE(DIVIDE([sum of Sales],[sum of Stock]))

The relationship of ‘Stock’ and ‘Sales’ is not ‘One - to - One’. If no ‘Stock’ column in ‘visual 1’, ‘sum of Stock’ doesn’t have any filter context. But in ‘visual 2’ and ‘visual 3’, it has. 

If you want to show right results in visual 1, you can create a column instead of a measure.

Best Regards,

Icey Zhang

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