Microstrategy to Power BI Migration

[Bhaskar123]

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_syn...

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

[v-rzhou-msft]

Hi @Bhaskar123 ,

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.