Ratio calculation in trial version

[Powernew]

Is it possible to do ratio calculation in the trial version? I didn't find a way.

[Powernew]

Thanks. The trial version is what I am using and the "Open data model" option seems to be not available to me.

[v-tangjie-msft]

Hi @Powernew ,

As far as I know only datasets with direct lake connection mode are supported.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[v-tangjie-msft]

Hi @Powernew ,

Select a dataset in the trial workspace, click "Open Data Model", and then create a new measure.

You can use the DAX language to create measures that calculate ratios based on your data. You can also use the DIVIDE function to perform a division operation.

You can refer to the following documents that may be helpful to you:

Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn

Calculating ratios in dax - Microsoft Fabric Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Powernew]

Thank you, Neeko! Do you happen to know if I can "open data model" in the web version (not the desktop version)? I'll surely keep your useful tips and try to use them!

[v-tangjie-msft]

Hi @Powernew ,

1.Find a trial workspace.

2.Find a dataset and click "..."->"open data model",then you can create measures.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.