Skip to main content

Power BI

Completed

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

Vote (1) Share
Poul Jorgensen's profile image

Poul Jorgensen on 25 Dec 2023 12:04:05

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] )