Fabric Capacity Metrics App

Hi,

I'm trying to build a custom report by connecting to Fabric Capacity Metrics dataset. What I'm trying to achieve is to have a metric that would show me '% of capacity being used by an individual' operation and item by date. Such a metric does exist within the dataset, but only works in the context of a single timepoint (timestamp). If I clear a filter on timepoint column that measure won’t render at all. I appreciate that I should not necessarily summarise a measure that was created for the specific dimension and granularity but I wonder why I can't get a total value for it when I clear timepoint filter.

I really chance it here as this is a very generic question but if someone has got any experience with Fabric Capacity Metrics dataset I would appreciate any pointers.

Many Thanks,

WJ