Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

MicroStrategy to Power BI migration process

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

 

 

2 Replies