My Power Bi Challenge (DAX and Filter of unrelated tables)

Posted by on

 

See what I got thank to PowerBi community member

https://www.youtube.com/watch?v=mZt0HJw4gjQ

https://www.youtube.com/watch?v=XbgLGDvWdWQ


DAX For this is:

MeasureColorPicker =
var _max = SELECTEDVALUE(ColorsDS[Color Choice])
Return
//CALCULATE(COUNTROWS(ColorTable),FILTER(ColorTable,CONTAINSSTRING(ColorTable[ChoiceList],_max)>0))
CALCULATE(COUNTROWS(ColorTable),FILTER(ColorTable,SEARCH(_max,ColorTable[ChoiceList],,0)>0))


Comments

Post a Comment