Forum Discussion
Quick Measure
I have a quick measure addition formula setup between to colums on two different tables. when i use my slicer to sort things it doesn't update the quick measure formula. is it because they the two tables are not connected in the data model?
jbenson Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490@Hi jbenson ,
DAX measure are based on row context so any given value from slicers, filters, interactions with other visualizations, variables, relationships and so on can influence your result.
Try to understand the quick measure you create, add a filter to the formula based on the current context, or create a relationship between the two tables.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- parry2kSuper User
jbenson Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490@- jbensonHelper III
when i click on the link it tells me the url is not any good anymore
- parry2kSuper User
- V-lianl-msftCommunity Support
Hi jbenson ,
DAX measure are based on row context so any given value from slicers, filters, interactions with other visualizations, variables, relationships and so on can influence your result.
Try to understand the quick measure you create, add a filter to the formula based on the current context, or create a relationship between the two tables.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.