Skip to main content
cancel
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.

Reply
fortuit
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.

 

Capture.JPG

2 REPLIES 2
Anonymous
Not applicable

@fortuit,

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

Capture2.JPG

Helpful resources

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