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'm looking for some help with the following issue.
I've calculated the following visualization table using measures for each output MIN, AVG, MAX, Q1, Q2, Q3.
Now I need to make an addition of those results per index, for instance, the 2 first lines have the index # 1, then I need to sum up the results of the MIN, AVG, MAX, Q1, Q2, Q3. Since the results comes from different measures, I'm not able to create a new visulization table grouping the results by index. Hope you can help me guys.
Solved! Go to Solution.
Hi @Jorge_Dier ,
Create measure as below:
sum_min = SUMX(FILTER(ALLSELECTED('table'),[index]=SELECTEDVALUE([index])),[min])
sum_avg = SUMX(FILTER(ALLSELECTED('table'),[index]=SELECTEDVALUE([index])),[avg])
...
etc.
Best Regards,
Jay
Hi @Jorge_Dier ,
Create measure as below:
sum_min = SUMX(FILTER(ALLSELECTED('table'),[index]=SELECTEDVALUE([index])),[min])
sum_avg = SUMX(FILTER(ALLSELECTED('table'),[index]=SELECTEDVALUE([index])),[avg])
...
etc.
Best Regards,
Jay
Why can you not just remove the extra fields and have index and the measures to get the view you want?
That's a good question but the results are not the expected ones because each tag description has a different name.
Expected results:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
74 | |
69 | |
65 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |