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.
Hello
I have a problem with a measure I want to make, below is dummy data:
Name Attribute Value
xx xa 1
xs gd 0
xx cd 1
Attribute and value are unpivoted columns. Now the measure I want to create, has to sum the values for each name. So not one big summation for all, but individually for each name. Is there any way of doing this?
Solved! Go to Solution.
Sorry misread the you wanted a measure.
= CALCULATE(
SUM(Table1[Value])
,DISTINCT(Table1[Name]))
Sorry misread the you wanted a measure.
= CALCULATE(
SUM(Table1[Value])
,DISTINCT(Table1[Name]))
You can just create a table with Name being the first value and Value being the 2nd.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |