Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Measure in PBI

Hi I have this table:

 

I need a measure to tell me how many of the concatenate fields are the same in the table.

for example, the concatenate field "1A" is two times in the table (one for Source "Red" and other with "Green". So the measure needs to indicates that the count is 2.

In the other hand, the concatenate 4E only appears 1 time, so the result of the measure is 1.

 

Which is the best way to build the measure?

 

Thanks

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , you can have measure like these and use that

    Measure = calculate(count(Table[Name]), allexcept(Table, Table[Name]))
    Measure green = calculate(count(Table[Name]), allexcept(Table, Table[Name]), filter(Table,Table[source]="Green"))

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , you can have measure like these and use that

    Measure = calculate(count(Table[Name]), allexcept(Table, Table[Name]))
    Measure green = calculate(count(Table[Name]), allexcept(Table, Table[Name]), filter(Table,Table[source]="Green"))