However, I have millions of data and 30 attributes. This solution will increase my data rows to : Millions of Data * 30, which is a lot. Every month, the data increases in size and I have to store that data in Power-BI Desktop. Is there any way to achieve the same scenerio without doing the unpivot option in the actual data ? Maybe by creating different measure for each metric and proceeding somehow to get the correct calculation ?
Thanks for the revert. But, I am not sure if this post is helpful in my scenerio where I want to put together the divison measure in one slicer for the graph. If I use this approach, I can have the legends of the division metrics in the graph with the metrics as slicer but won't be able to use the month as legend.