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...
@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])
What is 8 here? I dont need to sum my Ids, i need the list of Ids who has both version
Anonymous ,
So just switch total off from table property.
can you please explain why you did minus 2 in the second measure
Sorry for the typo. It was equal sign not minus.
Measure2 = CALCULATE(SUM('Table'[Id]),FILTER('Table',[Measure 1]=2))Please check again, i am not getting any values
also i see the case you have taken, you have already removed Id 2