Forum Discussion
Easy Dax solution required
@PoweeeBII, create a measure like the following and use with id in visual
medida :
var _max 2
devolución
countx(filter(summarize(Table, Table[Id], "_1",distinctcount(table[Version])),[_1] ?_max),[Id])
Super User@PoweeeBII, create a measure like the following and use with id in visual
medida :
var _max 2
devolución
countx(filter(summarize(Table, Table[Id], "_1",distinctcount(table[Version])),[_1] ?_max),[Id])
Cant I have this as a new column and pass true and false and then do the count. The issue I am seeing here is What if I have version 3 and then i need to check for Ids which has all the 3 version
amitchandak your solution works fine, but my question if my version increases like there are 3 versions possible for any ids and i would like to get ids with all versions, i will write var max= 3 and so on..but instead of hardcodiing if i go fo var max= distinctcount(table1[version]) it does not return the desired result..thogh the value is 2 if i check it seperately for distinctcount(table1[version]) . any clue what is wrong here?? i mean it doesnt seems to be binding with Ids when using in a matrix while with a hard coded value it works fine