I have a table with the values "disease" and "filtered patient table". Filter Patient Table is a measure. This measure is defined as
FILTERED PATIENTS TABLE = COUNTROWS(PATIENT). When the the table is filtered to DISEASE top 50 by FILTER PATIENT TABLE, the dashboard is really slow to load the first time. It takes around 30 seconds. I'm trying to figure out how to make this faster. Here is the DAX I pulled from the performance analyzer.
DEFINE MEASURE 'PATIENT'[FILTERED PATIENTS TABLE] = (/* USER DAX BEGIN */ COUNTROWS(PATIENT) /* USER DAX END */)