Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated measures not working correctly with calculated table

Hi everybody,    I have to create a price tiering in Power BI something like the picture below and the range can be variable anytime by the user.    For variability every product need a con...
Need Help
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

The measure is dynamic but the calculated tables are computed during the database processing and then stored in the model. So In your scenario, when the calculated table is generated, it will use the default value of parameter. We suggest to use the measure if you want the tiers can be dynamic by the selected value of parameter.

 

 


Best regards,