How to benchmark performance for a measure across multiple dimensions on the same page

[juliepoole]

Hi All,  I hope someone can help.  I have a feeling there is a simple solution but I can't find this easily by googling!

I have a measure = Sales

I have four different dimensions = National, State, Region, Accommodation Name

I am wanting to show on one page Sales related to each dimension for a particular date range eg:

National Sales Total,

State Sales Total,

Region Sales Total

Accommodation Name Total

I would also like to filter on Accommodation Name and then have the related Region and State sales apply as well as the total National Sales.    

Any help would be appreciated!

@needhelp @PBIHelp 

[v-chenwuz-msft · Accepted solution]

Hi @juliepoole ,

Power BI Desktop provide a tool to test the preformance of report, which includes dax query.

View ->Performance analyzer.

Or You can use DAX Studio

And this page will let you know how to test the performance of measure.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.