Just a smaill correction here, use country column when using 'ALL' Max_Point = var Max1 = MAXX(all(Orders[Country]),[TotalSales]) var Max2 = IF(Max1 = [TotalSales], Max1, BLANK()) Return Max2
I copied your function and it works, except the data label. IF i turn the data labels off there are non but if i turn them on, there are shown for every data point and not just for the min & max values.
we need to complete 10 page report in a short span , they assigned two BI developers under you. Now question was: How would you decide steps for the flow of project.
can you suggest me how to take max & min values based on four columns in matrix....those 4 columns are not direct columns they are written as measures.....so that those 2 values should be used in conditional formatting of those 4 columns and color it like heat map....Please suggest
I have a Card visual with Total Sales. I have a country slicer and if I select a country the sales of that country is visible in Card, but if I do not select any country in slicer I need the sales of India in card visual. Can you explain this. This was an interview question.
max(y) works only if y is a column . total_sales is a measure and cannot be used with max. However you can create a new table and use maxx on it Max_Value = var t = CALCULATETABLE( ADDCOLUMNS ( 'Table 3', "@TotalSales", [TotalSales] ), ALLSELECTED () ) return MAXX(t , [@TotalSales]) but MAXX is the short version
Hey. Can we change dynamically column name. Suppose in Slicer if we select January . In the table i want December sales along with title should be December
I think this should work according to your requirement. SelectedMonthSales = VAR SelectedMonth = SELECTEDVALUE('Date'[Month]) RETURN SUMX(FILTER('Sales', 'Date'[Month] = SelectedMonth), 'Sales'[SalesAmount])
Thank you for the video. In this case, say I use MAXX(ALLSELECTED('Table3'[Country],[Total Sales]) If I use Field parameters and try to switch between dimensions country/region + somemore from other tables, how you I do an allselected of field parameter's selected dimension. Could you suggest
When u apply a measure on any visual, the measure gets filtered by default (depends on the fields that you have used along with the measure in the visual), in this case you’ll not be able to get the max and min values without using ALL function. ALL function avoids the filter context in the visual. Hence, the measure identifies the max and min values from the column.
@@HappyAnalysing thank u so much alekya ....i confused alot whenever i saw using this ALL function in measures...with your words i can understand clearly what is going on with All function in measure