Looking for a specific visual (ratio and percentage between two measures)

[pmaurizi]

Hi, everybody,
I need to know if exists a visual that allows to place 2 measures, and shows the ratio between both measures, and the percentage between that ratio and one of them.

Something similar to KPI visual, but a little different

For example:
Measure 1: Operating expenses
Measure 2: EBITDA
I need to show the ratio between Measure 1 and Measure 2, and also the percentage that this ratio represents over Measure 1

Thank you very much in advance!

[amitchandak]

@pmaurizi, No very clear

Ratio = divide([Measure1],[Measure2])

Or

Ratio = divide([Measure2],[Measure1])

% of total = divide([Measure1],calculate([Measure1],all(Table)))

[pmaurizi]

Hi Amit, thanks for your answer.
You're right, maybe I wasn't very clear, sorry.
I'll try to explain better.
I know that DAX, what I need to know is, for this case, if there is a visual that replaces DAX.
I mean, that I can put in fields Value of the visual, the two measures, and then the visual calculate the ratio and percentage.

I have to show many indicators in one page, and I would like to do it with visuals, avoiding to build many dax, if it's possible.
Something similar to what the KPI standard visual does with the value and the target, where it returns the difference and the percentage.
Thank you!

[v-diye-msft · Accepted solution]

Hi @pmaurizi 

Based on my research, there's no visual available per your requirement currently.

Please kindly raise the idea in the portal to bring the new visual coming:

https://ideas.powerbi.com/forums/265200-power-bi-ideas