Microstrategy to Power BI Migration

Anonymous — Thu, 15 Dec 2022 15:02:08 GMT

Hi All,
I am migrating Micristaratagy reports to power Bi
while convert metric used in Microstratagy and i am unable to write in power BI measure

In Microstaratagy they calucaled Geo Stop count = Count(GeoStopNumber) with including curley bracket.

Curly bracket they called it level metric or level demention.

can you please help me how to write same thing in Power BI

Please find the more about level metric in MSTR for your reference;

https://www2.microstrategy.com/producthelp/2020/CommandManager/WebHelp/Lang_1033/Content/html/cm_syntax_examples/Metric_expression_syntax_Level__Dimensionality_.htm

https://www2.microstrategy.com/producthelp/Current/ReportDesigner/WebHelp/Lang_1033/Content/about_the_report_level_of_a_metric.htm

Re: Microstrategy to Power BI Migration

Anonymous — Fri, 16 Dec 2022 08:24:23 GMT

Hi @Anonymous ,

Here I suggest you to share a easy sample pbix file with your data model and show me a screenshot with the result you want. This will make me easier to find the solution than converting metric in Micristaratagy to Dax/M code in Power BI.

Best Regards,
Rico Zhou

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

topic Re: Microstrategy to Power BI Migration in Developer

Microstrategy to Power BI Migration

Re: Microstrategy to Power BI Migration