Forum Discussion
Solved
Incorrect division measure after filtering with Inputs from two different tables
Hello Everyone, I have an issue with a division measure called 'Breakdown %' that calculates based on column 'Breakdown Time(hours)' from Table1 and column 'Loading Time (hours)' from Table2. ...
MohamedKamel , Share the measure formula
a calculation like should work
Divide(Sum(Table1[Breakdown Time(hours)) , Sum(Table2[Loading Time (hours)]) )
Common column from Table3 should be used in visual
amitchandak
Super User
Super UserMohamedKamel , Share the measure formula
a calculation like should work
Divide(Sum(Table1[Breakdown Time(hours)) , Sum(Table2[Loading Time (hours)]) )
Common column from Table3 should be used in visual
amitchandak this is the measure formula currently used
% Breakdown = DIVIDE(SUM('Table1'[Breakdown Time(hours)]), SUM('Table2'[Loading Time (hours)]))
and as mentioned before it already works when no filter is selected or when a filter is selected from the 'Area' column but not when a filter is selected from the 'Line' column or the 'Machine' column.