So currently working on a migration project from GDS to Power BI and I have noticed that at many places, blends are being used in the reports to be migrated.
And I have noticed that a lot of times they are creating “metrics” inside of the blends and then using them outside of the blends to create yet other metrics. For example if you have a table with column A, B, C, D. They will perform a blend with the singular table and drag in column A, B and than a metric example SUM(C) named “C” too.
Then in the report, say inside a table visual they will use the column A, B along with the new metric C from the new blended table. But they will perform yet another calculation on this new “C”. For example a distinctcount when using it in the visual.
Sorry for the messy explanation but Im really struggling to wrap my mind around why they would do such things and what purpose it accomplishes or how metrics are even handles in Looker Studio for us to be able to do these kind of multilayered calculations on them,
Any help would be appreaciated and any tip on replicating this in Power BI is welcomed! Thanks guys.