Forum Discussion

SantiagoRandado's avatar
SantiagoRandado
New Member
2 years ago
Solved

Help With DAX Meassure

I have Table Sales with this fields: Value and Date and I have a Table Calendar with Date, Year, Month, Week, Day and Month_Name. I need to create a bar chart showing sales by week, making the last ...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, SantiagoRandado 

try below measure as conditional formatting

measure =
var a = selectedvalue(calender[date])
var b = maxx(filter(calender,calender[date]=a),calender[week])
return
if(calender[week]=b,"#FFFF00","#008000")

 

and follow step in below link solution

conditional formatting 

  • SantiagoRandado's avatar
    SantiagoRandado
    New Member
    2 years ago

    Thanks Dangar, the meassure give me this message "A single value for column 'week' in table 'calender' 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.". It is underline [week] inside the if. Do you know how to solve it?

    • Dangar332's avatar
      Dangar332
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      Hi, SantiagoRandado 

       

      measure =

      var a = selectedvalue(calender[date])

      var b = maxx(filter(calender,calender[date]=a),calender[week])

      return

      if(max(wcalender[week])=b,"#FFFF00","#008000")

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      2 years ago

      SantiagoRandado Looks like it is missing an aggregation:

      measure =
var a = selectedvalue(calender[date])
var b = maxx(filter(calender,calender[date]=a),calender[week])
return
if(MAX(calender[week])=b,"#FFFF00","#008000")
      • SantiagoRandado's avatar
        SantiagoRandado
        New Member
        2 years ago

        Greg_Deckler Dangar332 

        Thanks for your help. but all weeks are #008000, also the last week shown un the graph