Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

DAX Query View - Ability to update/create Multiple Measures simultaneously

Currently in DAX Query View you have the option to

  1. Click on Update model Overwrite Measure
  2. For existing ones
  3. Click on Update model Add new measure
  4. For ones just defined


These 'links' are on a line above of every measure.

It would be fantastic if a check box was in front of these, with the following functionality:

If multiple check marks are set, then clicking the link will create/overwrite All selected Measures.


This would greatly improve the ability to efficiently create measures within Power BI Desktop itself.


example (current):


DEFINE

-- link here with text : Update model Overwrite Measure

    MEASURE 'IMDB Top 250 movies'[Avg Rating] = AVERAGE('IMDB Top 250 movies'[IMDb Rating] )

-- link here with text : Update model Add new Measure

  MEASURE 'IMDB Top 250 movies'[Max Rating] = MAX('IMDB Top 250 movies'[IMDb Rating] )



Change (Suggested):

DEFINE

Check box in front of the text : Update model Overwrite Measure

    MEASURE 'IMDB Top 250 movies'[Avg Rating] = AVERAGE('IMDB Top 250 movies'[IMDb Rating] )

Check box in front of the text : Update model Add new Measure

  MEASURE 'IMDB Top 250 movies'[Max Rating] = MAX('IMDB Top 250 movies'[IMDb Rating] )


Status: Completed
Comments
DataZoe
Microsoft Employee

An "Update model with changes" button has been added to update all measure changes at once. https://learn.microsoft.com/en-us/power-bi/transform-model/dax-query-view#update-model-measures-usin...

fbcideas_migusr
New Member
Status changed to: Completed