Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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:
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |