storing and using measure names from a table

Hi ThomasDay, thanks for reaching out to me. If I've understood the question right, what you are trying to do is quite complex, so I can't think of a clean cut solution for solving this.

Here's how I've understood this so far:

For simplicity, lets say you have 1 report page with 3 card vizualizations (25th percentile, 50th percentile, 75th percentile).
You want to use a slicer with 100 + measure names, so that when you select a measure from the slicer, the three cards will reflect each percentile calculated with that measure. Eg. selecting FTEsAcuteCare from the slicer would result in the cards displaying each percentile for FTEsAcuteCare.

Let us know if this interpretation of the problem is close enough and maybe someone else might have a light bulb moment and step in :)

If this is accurate, then for one the measure should result in a vector of values, not a value, because you have to have a vector of values to be able to calculate a percentile. I assume that your measures are set up like this, so one solution would be to use the SWICH statement (as in the parameter table link above) where you check which value has been filtered from the measure table and catch the selected measure with a SWITH statement like:

25thPERCENTILE =
IF (
HASONEVALUE ( Measures[MeasureName] ),
PERCENTILEX.INC(ALLSELECTED([ProviderNo]),
SWITCH (
VALUES ( Measures[MeasureName] ),
"FTEsAcuteCare", [FTEsAcuteCare],
"2ndMeasure", [2ndMeasure],
...
)
, 0.25)
...

This is not dynamic as the measures have to be hardcoded into the dax-statement, but with good documentation and a mainenance plan for updating the dax-statements, this might be a simple enough approach.

Of course there could be a more dynamic solution to this, but let me know if this brings you any closer to a solution that would suit the requirements.