Forum Discussion

ells69's avatar
ells69
Icon for Helper I rankHelper I
2 years ago

Dynamic measures

Scenario This data set and report will be shipped to multiple clients. Each client will have their own data, semantic model and report. Each of these will be the same but individual for each client....
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

This sounds a little bit like RLS.  What you could do is use measure tables (I can't believe I just said that!!) and Field Parameters. That way you could map which customer can select which measures from the tables for the field parameters.

ells69's avatar
ells69
Icon for Helper I rankHelper I
2 years ago

RLS will not cover it. RLS will only affect what is there. It eill not allow you to add a new measure and add the DAX required for the measure.

I want Client 1 to be able to show a new measure called KPI 1 that shows the value "A" . This measure is in their configuration.  Client 2 will have in their configuration a new measure called KPI 1 that shows the value "B"   
I want Client 1 to be able to ammend the difinition for KPI 1 to show the value "C"
All of this to be done without changing the report or semantic model.

I am considering that this maybe a can of worms that I may not wish to open

Thanks