Skip to main content
Microsoft Idea

Power BI

Needs Votes

Improve the feature to calculate the function formula accurately when applying Quick measures.

Vote (1) Share
hiohta's profile image

hiohta on 09 Feb 2018 10:13:54

I am aware of that the user cannot get the expected value when creating Quick measures applied multiple columns created by Quick measures in Power BI.
For example, when you create the maximum sales value for each name with Quick measures, it becomes the following function formula.

"Maximum value of sales = MAXX(KEEPFILTERS(VALUES('Table'[Name])), CALCULATE(MIN(' Table '[Earnings])))"

However, the result of this formula is showing only a value to calculate the sales per line. Therefore, please consider improving the feature to calculate/display correctly the maximum value of sales even under the conditions we have mentioned. Thank you for your continued support.