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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

Ratio between two columns in Matrix Visual

Dear community,

I would like to create a new column (YtD Budget/Budget) in a table which is the result of the division of two columns in a matrix visual (see below ). I would like no having one single value but one per category (here: per row).

Does anyone know how to do it ? This is of course something really easy to perform in excel but less with DAX...

Thanks for the feedback.



Not applicable


Without seeingthe data model, you can create a measure like below: 

YTD Budget/Budget =
DIVIDE ( SUM ( 'Table Name'[YTD Budget] ), SUM ( 'Table Name'[Budget] ), 0 )


@ NickNg278 Thank you for the feedback.

However such a measure won't work in my case because YTD budget and Budget are coming from the same colum in my data base : FinMetric (see below). The target is to have a measure of the YTD perf : YTD Budg/Budget per country (here US and Turkey). I tried to do it this way via three measures :

YTD Budget = CALCULATE(SUM(FinalDB[FinMetric]);FILTER(FinalDB;FinalDB[FIN_Global1]="YtD Budget"&&FinalDB[FinMetric]>0))
Budget = CALCULATE(SUM(FinalDB[FinMetric]);FILTER(FinalDB;FinalDB[FIN_Global1]="Budget"))
YTD Perf = YTD Budget/Budget
But the final result is such that I only get one measure YTD Perf (on the whole sample) while I would like to have one per country... 


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.