Forum Discussion

Ericwhv's avatar
Ericwhv
Icon for Helper II rankHelper II
4 years ago
Solved

Power BI - Dax (Funnel)

Hi Everyone appreciate for your help in advance.   i am building a dashboard to show the most recent shipment details for below table, if i would like to show the HOUSE in red on the dashboard, h...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Add the measure to the visual filters and set it to "red"

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Not sure if I captured the logic behind your rules.

 

Font Color = 
var b = CALCULATETABLE('Table',ALLEXCEPT('Table','Table'[House]))
var l = countrows(filter(b,'Table'[LegCheck]="Last Leg"))
var c = countrows(filter(b,isblank('Table'[COB])))
return 
switch(TRUE()
,max('Table'[LegCheck])="Last Leg" && l>0,"red"
,isblank(max('Table'[COB])) && c >0,"red"
,l=0 && c=0 && max('Table'[COB])=maxx(b,[COB]),"red"
,"black")

 

see attached