Skip to main content

Power BI

Needs Votes

Allow calculated measures in web designer

Vote (222) Share
Stephen Moir's profile image

Stephen Moir on 12 May 2015 12:26:52

At the moment if you're using the web based designer, you're unable to create custom measures. This currently means you have to go back to the source data to add in all possible measures

Comments (18)
Stephen Moir's profile image Profile Picture

Josefina on 05 Jul 2020 22:36:10

RE: Allow calculated measures in web designer

We have calculated measures in a Cube but we can´t use them in Power BI, is there a way?

Stephen Moir's profile image Profile Picture

Power BI User on 05 Jul 2020 22:33:40

RE: Allow calculated measures in web designer

Would really like to be able to create measures in the Web Power BI, and not need to install the Desktop.

Stephen Moir's profile image Profile Picture

Ran on 05 Jul 2020 22:33:14

RE: Allow calculated measures in web designer

Adding the ability to edit/see or create a calculated field in the Web App would be great.
I'm connecting directly to Project Online via odata feed, some field are already calculated and i want to see how they were calculated but unable to. I do have a desktop version but it doesn't help me in that regard.

Stephen Moir's profile image Profile Picture

Michael Billing on 05 Jul 2020 22:25:37

RE: Allow calculated measures in web designer

This is a no brainer, since you would be able to use PBI Web to create real/quality reports on any data source. Thus using files in a cloud drive as datasource is way more userfriendly and flexible than the gateway system. And this feature would leverage this use case.

Stephen Moir's profile image Profile Picture

Kat Innes on 05 Jul 2020 22:18:13

RE: Allow calculated measures in web designer

I’m regularly asked for reports to be adjusted with different percentages. Every time a new percentage calculation is requested from a different business sector I have to update/redesign a desktop report and republish to the web or make changes to SQL data warehouse. It would be much more efficient for the business if department users with web designer access apply a calculated measure for themselves; particularly as many of the queries are not of long term interest.

Stephen Moir's profile image Profile Picture

Jeffrey Brown on 05 Jul 2020 22:17:42

RE: Allow calculated measures in web designer

The ability to live more in the browser and less in desktop will allow a much better enterprise distribution. We're creating models in ITS that we pass out to business units, and I don't want to have to re-create the dataset each time - the business units should have the power to change the model in their domain. This would provide that capability without having to force them into Power BI Desktop

Stephen Moir's profile image Profile Picture

Minsuk Kang on 05 Jul 2020 22:14:40

RE: Allow calculated measures in web designer

Please add this feature. We are importing data through REST API so web designer is only available. We cannot calculate success rate.

Stephen Moir's profile image Profile Picture

Tom Marek on 05 Jul 2020 22:04:34

RE: Allow calculated measures in web designer

This is especially an issue with Direct Connect sources like Azure SQL Database and Azure Data Warehouse since you cannot aggregate aq percentage from a fact table today.