Forum Discussion
How to divide from 2 measure
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.
Hi Matt
Below is my flat table :-
https://www.dropbox.com/s/s4rum78l5kzahlm/INVC_TS.csv?dl=0
Do you mean this table can be further improve ?
By the way i have AR Table below :-
https://www.dropbox.com/s/ll87ldkmwnafuk1/AR_TS.csv?dl=0
Can you give me some comment ?
Paul Yeo
Community ChampionIt is a very big topic. The first file is a single flat file, and it is very small. It is questionable if you would want to/need to invest in building a dimensional model in this case. Sometimes the effort is not worth the benefit. You have already written the measure combining the total of 12 columns, so you are not going to gain much now. Having said that, a better dimensional model would have a fact table with a single column for the S_ column values and an attribute column describing what the value refers to. What that means for the other columns is hard to say - it depends on what the data are.