Forum Discussion
How to divide from 2 measure
Hi All I have 2 measure , may i know how to create one more measure below :- Ratio = AMT_OH / AMT_AVE 1) measure AMT_OH = SUM(INVC[Unit Cost])*SUM(INVC[Avail]) 2) measure AMT_AVE =...
Ratio = DIVIDE([AMT_OH], [AMT_AVE])
it looks like your fact table structure is not idea. You should consider unpivoting the columns in your INVC table. This is quite a big topic that we cover in our Power BI dimensional modelling course at Skillwave.Training, but you can no doubt find other material on the web too.
MattAllington
Community Champion
Community ChampionBecause I have 6 year's experience in data modelling 😀.
Your measure AMT_AVE requires yo to add data from 12 columns. If you unpivoted the data you would only have to add from a single column. The other 2 columns may be best unpivoted too, or in another table - I can't say without looking