USE SLICER TO CHOOSE FROM A LARGE NUMBER OF MEASURES

[baldrich]

I have a rather large and complicated dashboard with over 700 measures that the end users can select (only one at a time) to populate a matrix. I have the measures split into four groups already using dynamic tables (Counts, Rates, Ratios, Averages) - the problem I'm having is the "switch" methodology to use a slicer to choose a metric seems to work very slowly. Almost as if it's calculating every measure within the switch formula before populating the visuals themselves. Because I'm populating a table/martix I can't seem to find a methodoly that will work faster. I wish there was a "indirect" formula to almost put brackets around the text from the selected value in the slicer

SELECTED MEASURE = "["&SELECTEDVALUE(SlicerTable[SlicerColumn])&"]" obviously just provides text. All of my measure names (text) line up 100% with measure itself. 

Help me bi-kenobi, you're my only hope,

Shane

[ivan_larson_cki]

I'm not sure if there's a better solution in the DAX for what you're looking for, but how did you wind up with over 700 measures? There might be a way to pare that down.

[baldrich]

The organization I support sells a wide varierty of products/services, each one has a specific set of KPIs that they need to track over time.