Forum Discussion

jovalle50's avatar
jovalle50
Frequent Visitor
1 year ago

Fabric Capacity Metrics App DAX measures

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 real...
Need Help
Show and Tell
Tips and Tricks
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

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's avatar
    jovalle50
    Frequent Visitor
    1 year ago

    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