Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I have 2 measure , may i know how to create one more measure below :-
Ratio = AMT_OH / AMT_AVE
1) measure
Solved! Go to Solution.
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.
Because 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
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
It 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.
Hi Matt
Thank you for the expression it work,
May i know how you know my data model structure is no good ?
Paul
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |