Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Easy Dax solution required

I have a table like this below and I would Like to get only those Ids which has both the version present in Version column. So in below table I would like to get list of IDs or count of Ids which has...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @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])

amitchandak's avatar
amitchandak
Super User
5 years ago

@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])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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