Power BI Quick Measure Suggestions now different?

[melimob1]

Hi, 

I used to see Quick Measures suggestions and now I only see this: 

and can't find any tutorials on how to use?

Many thanks

Melissa

[mattiasdesmet · Accepted solution]

To be able to use Copilot, you'll need a P1 or F64 capacity. Your workspace needs to be on that capacity and you'll have to be in a security group that is allowed to use Copilot in the organization.

[mattiasdesmet]

Hi,

this does allow you to create a quick measure by using the calculation you would like, similar to previous wizard:

Generating a quick measure

key average per  value =

AVERAGEX(

    KEEPFILTERS(VALUES('blankdata'[ value])),

    CALCULATE(SUM('blankdata'[key]))

)

The quick measure suggestions are now using copilot which can generate the DAX based on your prompt:

Write DAX queries with Copilot - DAX | Microsoft Learn

You would need PowerBI Desktop to be connected to a workspace with Copilot. And in options, Copilot connect PBI Deskto to this workspace. Next you'll want to enable to preview feature "Write DAX with Copilot" for this to work.

You'll then see the option "suggest measures"

[melimob1]

thanks for the advice mattias 

I managed to navigate to DAX and blank query to try after following instructions in your link however get this error:

Perhaps it's blocked by our company?

[v-linyulu-msft · Accepted solution]

Thanks for the reply from mattiasdesmet , please allow me to provide another insight:

Hi, @melimob1 
Could you please let us know if mattiasdesmet's response resolved your issue? If it did, kindly accept it as the solution.

As mattiasdesmet mentioned, you do indeed need to be within a specific capacity. Here are the relevant document screenshots:

For further details, please refer to:

Create reports in Power BI Desktop with Copilot - Power BI | Microsoft Learn
Overview of Copilot for Power BI - Power BI | Microsoft Learn
 

Additionally, here are some documents related to your issue that I hope will be helpful to you:

 Use Copilot to create measure descriptions (preview) - Power BI | Microsoft Learn
Create reports in the Power BI service with Copilot - Power BI | Microsoft Learn

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mattiasdesmet · Accepted solution]

To be able to use Copilot, you'll need a P1 or F64 capacity. Your workspace needs to be on that capacity and you'll have to be in a security group that is allowed to use Copilot in the organization.