These 2 tables are linked with a Calendar table and Location master.
Now if the user selects location as L1 , then 'Value'= 100. But if the user selects cutsomer as C1 , then Power BI would give 'Value'=100. This would be wrong information as Table1 cannot be bifurcated customer wise and should instead give no value ( or 0 value) rather than giving 100.
How I can ensure to get a blank value or 0 value for Value column in Table1 if the user filters data by item & customer wise?