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.
Morning,
Maybe one of you experts could help me out with the following
I have the following table and would like to calculate the following
Table:
Field0 field 1 field 2 field 3
1 xyz 200 1.000
2 xyz 300 1.000
3 xxx 400 500
4 yyy 200 200
5 yyy 100 200
6 abc 150 300
7 bbb 150 300
The derised outcome/matrix:
field 1 field3
xyz 1000
xxx 500
yyy 200
abc 300
bbb 300
Total 2300
So only show field 1 the unique values ( so no doubles) and field 3 the value that belongs to that unique value. And very important a total field for field 3.
Your help is greatly appreciated!
Solved! Go to Solution.
Hi @hjansen1976 ,
You can create a new table with below code:-
Table 2 = SUMMARIZE('Table','Table'[field 1],'Table'[field 3])
Output:-
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @hjansen1976 ,
You can create a new table with below code:-
Table 2 = SUMMARIZE('Table','Table'[field 1],'Table'[field 3])
Output:-
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Many thanks for your help!
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 |
---|---|
100 | |
100 | |
86 | |
71 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |