Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, pretty new to Power BI
this is my sample data:
I created a matrix out of the same which looks something like this:
I have to perform a division on the Total column as in I want the values to be divided by 7 and display it as a new column. How do I have to approach this?
Solved! Go to Solution.
Hi, @Tahreem24
You can't use matrix table and only show two totals in it at the same time.
What can be done:
If you only need to change total to total record and nothing else.
You can create a measure to modify total.
Like this:
Total Record =
VAR _Total =
SUM ( Table[No of records] )
RETURN
IF ( SELECTEDVALUE ( Table[Month] ) <> BLANK (), _Total, DIVIDE ( _Total, 7 ) )
If you need to show two totals, you need to use table visual, so you need to pivot column to get the matrix table in pq, then you can create two measures to show total and total records.
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Hi, it is working but it seems to add up in every column values as a record in the matrix. Is there any way to show this as a single seperate column alone, like the TOTAL column
@Anonymous I guess that's not possible to add like a Total which is inbuilt column from Martix visual itself. Otherwise take the Month column under Process type.
Hi, @Tahreem24
You can't use matrix table and only show two totals in it at the same time.
What can be done:
If you only need to change total to total record and nothing else.
You can create a measure to modify total.
Like this:
Total Record =
VAR _Total =
SUM ( Table[No of records] )
RETURN
IF ( SELECTEDVALUE ( Table[Month] ) <> BLANK (), _Total, DIVIDE ( _Total, 7 ) )
If you need to show two totals, you need to use table visual, so you need to pivot column to get the matrix table in pq, then you can create two measures to show total and total records.
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
@ Try this Measure DAX:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |