Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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"))
@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"))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |