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.
Hello!
I need to take the Total Line from numerous tables and put them in one table!
Every green box is a table's total which derives from different filters in each table. The task is to create a table that looks like this:
Column1 | Column 2
A1A2 + A3A2 + A3 + A1 + A | 788
B1B2 + B1B3 + B2 + B + B | 372
C1C3 + C2C3 + C2 + C | 452
D | 620
- | 38
Any ideas?
Thanks!
Hi @alex_smith ,
Sorry I'm not very clear about where are the values in green box from. Could you please explain more about the expression "Every green box is a table's total which derives from different filters in each table."
Best Regards,
Community Support Team _ kalyj
Every green box is a table visual. For example the A1A2 is the total counts of this table. I have renamed the "Total" with A1A2, A3, A1 etc. For instance, A1A2 - 126 means that the total counts (sum of the rows) on this table visual is 126. Each table (i.e. each green box) has different filters on it that is why I have different totals. Basically I need to extract the total of each table and then sum it. Please feel free to ask if it isn't still clear.
Another approach that would lead to a possible solution is this:
I want to create a measure that count rows from a table
Measure1 = COUNTROWS(Table1)
and then filter it by three measures:
Measure2 < 0.04
Measure3 < 0.04
Measure4 >= 0.15
Any clues?
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 |
---|---|
119 | |
106 | |
78 | |
73 | |
52 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
65 |