Forum Discussion

melimob1's avatar
melimob1
Icon for Helper I rankHelper I
1 year ago
Solved

Power BI Quick Measure Suggestions now different?

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

4 Replies

  • 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:
    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's avatar
      melimob1
      Icon for Helper I rankHelper I

      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?

      • mattiasdesmet's avatar
        mattiasdesmet
        Icon for Resolver II rankResolver II

        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.