Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
120 | |
66 | |
66 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
68 | |
65 | |
54 |