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.
Hi,
Because some of the rows are not applicable based on the filter value, it does not show up in the matrix table. However, the total it displays at the bottom includes those missing data points. How do I get just the total of the lines displayed?
Solved! Go to Solution.
You may use SUMX Function to add an additonal measure.
You may use SUMX Function to add an additonal measure.
for example, the table is as below.
NPI # of patients seen (measure) Service
A 20 1.1
B 30 1.1
C 10 1.2
D 40 1.2
Service is a filter. When I select 1.1 service, the matrix shows below:
NPI # of patients seen
A 20
B 30
-----------------
Total 100 <-- this is incorrect. it displayed 100 because all 4 NPI totalled 100. However, the right total should have been 50. How woudl i get 50 there? (20+30)
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |