Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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