Skip to main content

Power BI

Needs Votes

Allow calculated measures in web designer

Vote (220) 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

831752ea aaeb-4ecd-b39b-551344bcc0ad 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

bfae519a 9641-4e2a-9fbc-5bc845a4fa42 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

fa5803d1 df93-4d42-9ce6-65cb931e2af2 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

77b6388c fe80-4147-9b7e-74eef7f38b04 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

821e85dc 6a81-4fb0-b514-72025017e4bf 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

08bbb4cf e0e7-4703-b0fd-3de3dff913b9 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

4b9062c2 fb23-492a-8ce5-60df7c0099ba 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

66886562 7ffe-4af9-ad13-21d2e1d73d11 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.