I have been looking for this technique. I watched many youtube videos but none of them really explained what they were doing. You did. I had to adjust for my tables and columns, but I did get it to work. Thank you!
Really good. I have a table with individual cities, regions and national values I wanted to display a chart when I select the region it should display cities, regions and nation all in one chart and colour the region, nation and cities with different colours. Any suggestions please.
Awesome... I have 2 values for a month for different categories..... I am showing max value in my table and matrix I want to apply conditional formatting on max and min value present in chart. max is working but min is not out of all maximum values I want to find max and min. Any way to do that?
I used a line chart and visualize date by sales and below create a table visual for date and sales and 10 columns added for more related information so here issue with these both visuals not interacted with each other when I selected date in the line chart it's not affected in a table visual. I want to know the reason for this issue
Hi Chandeep, I had a situation where I have to highlight Min and Max average of percentages in each column in Matrix which will change dynamically according to the slicer selection. Could you please help me to sort it out?
Sorry to bother again but I resolved the issue outlined below but didn't delete it because someone else might benefit from the answer. The important factor is that the value in the MAXX expression must be an AGGREGATED measure. In this example [Total Sales] is actually a summed measure - e.g. Total Sales = SUM([Sales]). The answer was in the error message - it just took me a while to finally get it ! ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Hi Goodly, love your videos and am wondering if you could help with my problem. When I copy your example DAX code as follows:- MAXX(ALL('Calendar'[Month], 'Calendar'[Index]), [Total Sales] ) I get the following error:- "A single value for column 'Total Sales' in table 'SalesOrderHeader' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result." The SalesOrderHeader table contains only about 3000 orders with the order dates spanning across 3 years. If I use "SUM([Total Sales])" the formula is accepted but the result is not a MAXX - it is the same as "SUM([Total Sales])" without the MAXX. This happens with everything I try including SUMMARIZE and other code that I have found to calculate the max or min value when the value is an aggregated total by date period such as Month. I feel that I am missing something fundamental.
And , if insted highlight de maximum I needed to show the total , for example , I have 12 or 6 or 8 months in a line chart with a bar chart at the end showing the total ? Do you accept the challenge ?
Sample DAX Code from Video... MAX Sales Cf = VAR MAXSALES = MAXX( ALL('Calendar'['Month'],'Calendar'[Index]), [Total Sales] ) VAR Color = IF ( [Total Sales] = MAXSALES, "Green", "Light Grey" // You can also use HEX Codes for colors // "#Dc661e", // "#d3d3d3" ) RETURN Color
I have been looking for this technique. I watched many youtube videos but none of them really explained what they were doing. You did. I had to adjust for my tables and columns, but I did get it to work. Thank you!
Thank you Joseph :)
Again, you always make it so easy to understand. Thank 3.
Awesome Chandeep! Thanks for sharing this great technique :)) Thumbs up!!
Excellent resolution. Thank you Chandeep!
Nice tutorial, can you explain what would happen if we use sum(sales) instead of [total sales ] measure?
That was a awesome technique and tutorial, definitely using this great tip going forward 👍
Awesome Solution Chandeep. Thanks for the video👏
Wow, that was awesome. thank you so much!
@GoodlyChandeep how can i select all year with the same visual want to see total year max and min(2001/2002/2003/2004)
Hey chadeep, i was looking for the same scenario. But my measure is showing in the conditional formatting options
2:45 why do you also add the index column through which the months are sorted by? why does the DAX does not work without it?
I like the way you explain about each problem❤️
Glad to hear that
Thanks for this great technique.
Great teacher with awesome technique!
Request you to do one video for UCL , LCL with detailed explanation. Thank you in advance
Really good. I have a table with individual cities, regions and national values
I wanted to display a chart when I select the region it should display cities, regions and nation all in one chart and colour the region, nation and cities with different colours. Any suggestions please.
Fantastic. Thank you
Thanks for this great tutorial 😊
Awesome...
I have 2 values for a month for different categories.....
I am showing max value in my table and matrix
I want to apply conditional formatting on max and min value present in chart.
max is working but min is not
out of all maximum values I want to find max and min. Any way to do that?
I used a line chart and visualize date by sales and below create a table visual for date and sales and 10 columns added for more related information so here issue with these both visuals not interacted with each other when I selected date in the line chart it's not affected in a table visual. I want to know the reason for this issue
Hello, thanks for the video. Can you share the data tables please. I like to generate the same results on my own. Ms excel tables are fine. Thanks.
Thank you very much! Great explanation.
hello - why it shighlighting on me many green values and some also grey , basically its highlighting all green values that are high
Hi Chandeep, I had a situation where I have to highlight Min and Max average of percentages in each column in Matrix which will change dynamically according to the slicer selection. Could you please help me to sort it out?
Thank you so much! I was able to do it and I used another variable for min value using the same logic as you explained :D
Cool!
Thanks Man!
Good one! Thank you.
Sorry to bother again but I resolved the issue outlined below but didn't delete it because someone else might benefit from the answer. The important factor is that the value in the MAXX expression must be an AGGREGATED measure. In this example [Total Sales] is actually a summed measure - e.g. Total Sales = SUM([Sales]). The answer was in the error message - it just took me a while to finally get it !
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Hi Goodly, love your videos and am wondering if you could help with my problem. When I copy your example DAX code as follows:- MAXX(ALL('Calendar'[Month], 'Calendar'[Index]),
[Total Sales]
)
I get the following error:- "A single value for column 'Total Sales' in table 'SalesOrderHeader' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
The SalesOrderHeader table contains only about 3000 orders with the order dates spanning across 3 years.
If I use "SUM([Total Sales])" the formula is accepted but the result is not a MAXX - it is the same as "SUM([Total Sales])" without the MAXX. This happens with everything I try including SUMMARIZE and other code that I have found to calculate the max or min value when the value is an aggregated total by date period such as Month. I feel that I am missing something fundamental.
What if the max value is same for two months, will it highlight the those two months right
Yes it should!
Thank you very much...It helped me a lot.
Glad it was helpful!
And , if insted highlight de maximum I needed to show the total , for example , I have 12 or 6 or 8 months in a line chart with a bar chart at the end showing the total ?
Do you accept the challenge ?
Thanks for share!
@Goodly Hello man, I want to ask you, if I want to get the 5 largest values to highlight? please guide me
You'll find your answer in this video www.goodly.co.in/top-n-and-others-power-bi/
@@GoodlyChandeep thank you so much
subtract previous day calculated measure value from till date highest calculated measure value.. dax formula..
Thanks bro 🙏🏿
Kudoes to you, Chandeep
Great explanation
Thanks Wyn, great to have you here!
Bhai yo index m kya h
Лучший
Super
Cool...
Sample DAX Code from Video...
MAX Sales Cf =
VAR MAXSALES =
MAXX(
ALL('Calendar'['Month'],'Calendar'[Index]),
[Total Sales]
)
VAR Color =
IF (
[Total Sales] = MAXSALES,
"Green",
"Light Grey"
// You can also use HEX Codes for colors
// "#Dc661e",
// "#d3d3d3"
)
RETURN
Color