Forum Discussion
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 both version 1 and 2 in here it will be ID 1 and 3. Thanks in Advance!!
| Id | Version |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 3 | 1 |
| 3 | 2 |
@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])
10 Replies
@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 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
Anonymous ,
You can make it happen by creating 2 measures:
Measure 1 = CALCULATE(COUNT('Table'[Version]),ALLEXCEPT('Table','Table'[Id]))Measure2 = CALCULATE(SUM('Table'[Id]),FILTER('Table',[Measure 1]=2))Anonymous ,
So just switch total off from table property.
