Forum Discussion

CRyan1984's avatar
CRyan1984
Frequent Visitor
5 years ago

Measures and Efficiency Advice

My question is around the efficiency of measures in Power BI.  I have a large table and several measures that have similar components. for example, I have 12 index measures similar to the below: ...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Not totally clear on your model/data but it seems like you could merge those two tables on the column you are using for the relationship.  In any case, a more efficient would be to leverage the relationship to propagate the filter from one table to the other (two CALCULATES instead of four).

 

Pat

 

CRyan1984's avatar
CRyan1984
Frequent Visitor
5 years ago

could you give me an example of propagating the filter from one table to another in regards to a measure?  I don't think I am familiar with this.