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 Team,
The potential requirement would be to get in the report just the yellow total lines in matrix form( no need to display the details).
Is there any possible way can display only total lines in matrix?. Could you please help on this.
Thank you.
Solved! Go to Solution.
Hi,
According to your description, i create a sample to test:
Then try this measure:
_Sales = IF(ISINSCOPE('Table'[Sales]),BLANK(),IF(ISINSCOPE('Table'[Region]),BLANK(),IF(ISINSCOPE('Table'[Country]),BLANK(),SUM('Table'[Sales]))))
The new [_Sales] shows no data but only total compared with original [Sales]:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
According to your description, i create a sample to test:
Then try this measure:
_Sales = IF(ISINSCOPE('Table'[Sales]),BLANK(),IF(ISINSCOPE('Table'[Region]),BLANK(),IF(ISINSCOPE('Table'[Country]),BLANK(),SUM('Table'[Sales]))))
The new [_Sales] shows no data but only total compared with original [Sales]:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
Do not put anything to row , just put in column and values
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |