Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys,
i have a table looking like this and i want to create the Group sum in each row for each article. So basically i want to add the numbers in the red circle as a measure to the table:
You can find the mini example here:
https://www.file-upload.net/download-14004880/Example.pbix.html
And how can i better attach example files to questions than with a link like that?
Thanks!
Solved! Go to Solution.
So I would think:
Measure =
VAR __Group = MAX('Table'[Article Group])
VAR __Table = FILTER(ALL('Table'),[Article Group] = __Group)
RETURN
SUMX(__Table,[Stock reach days])
So I would think:
Measure =
VAR __Group = MAX('Table'[Article Group])
VAR __Table = FILTER(ALL('Table'),[Article Group] = __Group)
RETURN
SUMX(__Table,[Stock reach days])
Perfect it works! Thansk alot
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |