Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi everyone.
I have a matrix like below.
I want to add new measure to matrix not filtering by columns.
Like this :
How can i achieve this
Thanks in advance.
@Omarov23 Hello Omarov,
you can use below method .
I am assuming you have seperate AZN currency column then follow below steps.
Step 1 ; You can create a new measure like.
Measure = if ( selectedvalue(table[Currency])= "AZN",Sum(table[Currency-AZN]*0.28,blank())
step2 : drag your measure then output will be like this.
Thanks
Harish M
If it is fulfill your requirement then accept it as solution and give Kudos anyway.
Hi @HarishKM .Thank for answer.
Every rate in the matrix is different measure just filtered by two banks.When i add measure [AZN] * 0.18 it also filtered by banks.Like below :
But i need only one column in matrix.
Hi @Omarov23
Do you want just a total column? This is available, you may need to turn it on though. Highlight the Matrix and click on format then adapt the Total columns
Thanks
Joe
If this post helps, then please Accept it as the solution
Hi @JoeBarry
Thank for answer. But i need custom calculation which is [AZN] * 0.18
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
70 | |
68 | |
50 | |
32 |
User | Count |
---|---|
115 | |
100 | |
73 | |
65 | |
40 |