Forum Discussion

Giovani's avatar
Giovani
Helper I
5 years ago

Dynamic filter bases on two columns

I am struggling with something that may be simple to solve. I want to make a dynamic bar chart, by year and month, to present counts of distinct ID that fits the criteria based on columns Filter1 and...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Giovani , First 2 should be possible using

measure =
var _cnt = countrows(selectedvalues(Table[Filter1]))
return
countx(filter(summarize(table,Table[ID],"_1" ,calculate(distinctCOUNT(Table[ID]))),[_1]=_cnt),[_1])

 

Last on can not be dynamic unless you can cat two fields or try like


measure =
var _cnt = countrows(selectedvalues(Table[Filter1]))
return
countx(filter(summarize(table,Table[ID],"_1" ,calculate(distinctCOUNT(Table[ID]), filter(Table, (Table[Filter1] ="A" && Table[Filter2] ="D") || (Table[Filter1] ="B" && Table[Filter2] ="E" )))),[_1]=_cnt),[_1])

Giovani's avatar
Giovani
Helper I
5 years ago

amitchandak  Thanks for the help. But I couldn`t make it work.

Syntax error:

The syntax for 'Table' is incorrect. (DAX(var _cnt = countrows(selectedvalue(Table[Filter1]))returncountx(filter(summarize(table,Table[ID],"_1" ,calculate(distinctCOUNT(Table[ID]))),[_1]=_cnt),[_1]))).