Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |