Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I am extemely new to Power BI and as such I'm having some problems with DAX. I have found a formula that currently works for me using various slicers and these include a site name, user name, category, result and date and time. I also have found away to limit the figures I need with a TopN slicer. The formula I am using to sum various fields is as follows:
If you're looking for the max & min of 'VW_TEST_EVENT'[CLEARANCE_OBSTRUCT_TOTAL] when filtered to the TopN then you can use exactly the same formula you have replacing SUMX with MINX and MAXX
Hi Johnt75
Thanks for getting back to me.
I did try that and what it seems to be doing is showing the max for that particular column and not the max of the combined users.
I've been using the following the following equation:
I don't think I understand what you are trying to calculate
User | Count |
---|---|
90 | |
84 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |