Forum Discussion
Poor Measure Performance and Confusion
I have simple data model shown below. The notable point is that the dimension table has 3.5m rows of data (a list of engagement codes). I would like to generate a table visual that looks lik...
I will have to look at the option but I still don't understand why adding the measure causes the issue in the first place since all of the relevant columns relate to the fact table. I don't understand what the DAX is doing and why it is simpacted by the large dimension table in the first place.