Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
Omarov23
Frequent Visitor

add measure to matrix

Hi everyone.
I have a matrix like below.

1.png

I want to add new measure to matrix not filtering by columns.
Like this : 2.png

How can i achieve this 
Thanks in advance.

4 REPLIES 4
HarishKM
Power Participant
Power Participant

@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.

 

HarishKM_0-1693220403552.png

 

 

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 :

Screenshot 2023-08-29 100404.png

But i need only one column in matrix.

2.png

JoeBarry
Solution Sage
Solution Sage

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 

JoeBarry_0-1693204490464.png

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.