Power BI
CompletedDAX Query View - Ability to update/create Multiple Measures simultaneously
Poul Jorgensen on 25 Dec 2023 12:04:05
Currently in DAX Query View you have the option to
- Click on Update model Overwrite Measure
- For existing ones
- Click on Update model Add new measure
- 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] )
Zoe Douglas (administrator) on 21 Aug 2024 00:33:21
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-using-codelens:~:text=Alternatively%2C%20you%20can%20add%20or%20overwrite%20multiple%20measures%20at%20once%20by%20clicking%20the%20Update%20model%20with%20changes%20button%20in%20the%20Command%20bar.