Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |