Hello,
I need to leave only total and remove where the yellow is marked.
Any ideas?
it's example:
Solved! Go to Solution.
Hi, @polonez1
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, @polonez1
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.
@polonez1 , 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/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
214 | |
54 | |
46 | |
41 | |
41 |
User | Count |
---|---|
278 | |
210 | |
73 | |
73 | |
65 |