Forum Discussion

juliepoole's avatar
juliepoole
Frequent Visitor
4 years ago
Solved

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

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 

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

1 Reply

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support

    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.