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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

can you please explain why you did minus 2 in the second measure

Tahreem24's avatar
Tahreem24
Super User
5 years ago

@PoweeeBII ,

Sorry for the typo. It was equal sign not minus.

Measure2 = CALCULATE(SUM('Table'[Id]),FILTER('Table',[Measure 1]=2))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Please check again, i am not getting any values

    also i see the case you have taken, you  have already removed Id 2

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I see whats wrong, my version is of text type and not integer, and so is the Id, how do i handle that?