Fabric Capacity Metrics App DAX measures

[jovalle50]

Hi community, 

For a few weeks now I have been looking for a way to analyze the Fabric Capacity Metrics App data from within Desktop to create a charge back model for capacity consumption. I realize that when connecting live, or even pulling in selective table into DirectQuery, there still isnt a way to view how the DAX measure were actually written in the Metrics App data model. 

Does anyone know where I could find out how they were written? Is there a way in DAX Studio or something?

Thank you in advance for your help!

JP

[Anonymous]

Hi @jovalle50 

Has your problem been resolved? If so, could you mark the corresponding reply as the solution so that others with similar issues can benefit from it?

Best Regards,

Jayleny

[rajendraongole1]

Hi @jovalle50  - Using DAX Studio or Tabular Editor is your best bet for inspecting the existing measures if they're accessible. If the measures are not exposed, combining Performance Analyzer with community or Microsoft resources might help. Alternatively, you can replicate the app's logic by exporting data and creating your own model.

you can check on the DAX Studio to Inspect the Model, you use DAX queries to explore how metrics are calculated

EVALUATE
ROW("Measure Definition", FORMAT_STRING(MEASURETABLE[Measure]))

also analyze with Tabular Editor will give you deeper insights.

[jovalle50]

Thank you do much for responding! I will proceed with trying this option out and make sure to thumb-up if it works. Thanks again!

JP