Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |