Well. Will there be any conflict if we have four fact tables and join them with the same dimension Tables?
I have made two layouts of single Fact Table.
1- Preferred Layout: I put the attributes in each separate column. Unfortunately, I am still not able to directly aggregate the columns as different corresponding technologies and commodities have to be filtered.
2- Type-2 Layout: I am seriously thinking about this as Fact Table. All attributes are in same column and will be filtered through DAX or using visual filters.
3- Third option may be the totally separation of GW, GWh, kT, mvkm etc. It needs extensive work in Power Query and developing four different Fact Tables.