Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |