Home » DAX » Quick measure suggestions in Power BI

Quick measure suggestions in Power BI

Quick Measure Suggestions

Microsoft Power BI update “Quick measure suggestions” feature in Oct 2022. This feature is in experimental preview for users to test and give feedback.

Quick measure suggestions help us to write a DAX measures using natural language instead of using templates or writing DAX from scratch.

Enable this feature

File > Options & Settings > Option > Preview Features > Turn on Quick measure suggestions. After this restart the Power BI file.

Quick measure Suggestion

Quick measure Suggestion

Note:- Currently, this feature is only deployed to US datacenters (East US and West US). If your data is outside the US, the feature will be disabled by default unless your tenant admin enables.

Quick measure Suggestion Admin tenant

Quick measure Suggestion Admin tenant

Let’s get started-





Now go to the Home ribbon tab and click on Quick measure > Suggestions

Quick Measure Suggestion tab

Quick Measure Suggestion tab

In this suggestions window you can describe the measure which you want to create and click on Generate button, see the example below-

Generate Quick Measure

Generate Quick Measure

And if you want to add this measure in your file, click on Add button.

Example 2-

How to get Average sales of each product-

Avg Sales Per product

Avg Sales Per product

Refer DAX post:- DAX Tutorials

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.



Leave a Reply