Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I need to leave only total and remove where the yellow is marked.
Any ideas?
it's example:
Solved! Go to Solution.
Hi, @Anonymous
You can try the following methods.
Sample data:
Measure:
Sum1 = SUM('Table'[Value1])
Sum2 = SUM('Table'[Value2])
This is the view at the beginning
Measure = IF(HASONEVALUE('Table'[Region]),[Sum1],[Sum1]&" "&[Sum2])
Then modify Total's name.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
You can try the following methods.
Sample data:
Measure:
Sum1 = SUM('Table'[Value1])
Sum2 = SUM('Table'[Value2])
This is the view at the beginning
Measure = IF(HASONEVALUE('Table'[Region]),[Sum1],[Sum1]&" "&[Sum2])
Then modify Total's name.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , need like hybrid display
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |