I can’t use measure as a chart legend to categorize the data
Hello! I have a dataset like this: Date Client Total Sales Sales Prev Diff Sales MRR Measure 2024/January A 200 200 New 2024/February A 500 -200 Lost 2023/January B 100 New 2024/January B 650 150 Reactivation 2024/February B 150 -150 Lost 2023/December E 11885 New 2024/January E 6265 11885 -10670 Reduction 2024/February E 1515 -1215 Lost 2024/March E 6270 6970 Reactivation 2024/April E 64850 6990 7880 Expansion 2024/May E 3650 14850 -11700 Reduction I have written a DAX code as a measure. The code is as follows: MRR Measure = if([firstD]=1,"New", if(and([Total Sales]>=0,[Sales Prev]=0),"Reactivation", if([Diff Sales]>=0,"Expansion", if(and([Total Sales]=0,[Sales Prev]<>0),"Lost", if([Diff Sales]<0 , "Reduction"))))) and the code for the Different Sales: Diff Sales = [total sales]-[sales prev] I want to add a bar chart based on this different sales value and the date. It gives me something like this: I want something like below, but because I have written a measure I can’t move it to the legend field in the chart. What should I do?
Help! Best by category dinamically using DAX (.pbix attached)
Hello everyone! I am asking for your help because, despite searching, I cannot find a way to create this DAX function. I uploaded here a .PBIX FILE EXAMPLE. Simplified version of the problem follows. I'm in this situation: And want to obtain this: I have a table containing store, category and a mymeasure (a measure). For each category I need to find the best store. The calculation of the best store must be dynamic on the selected month, but must not consider any filters on the category or store. I was able to calculate the value the best measure of that category. This is how i made value_highest_in_category: value_highest_in_category = CALCULATE( MAXX( SUMMARIZE('Data', 'Data'[store], "myMeasure", [measure]), [measure] ), ALLEXCEPT('Data','Data'[month]), 'Data'[category] = MAX('Data'[category]) ) but I just can't extract the name of the corresponding store. I thank anyone who can help me!
