Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Microstrategy to Power BI Migration

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

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.