full set of dimensions with a complex formula

[socura]

Hi,

i would like to create a bar chart with fixed values of all dimensions just like sum({1} amount).

But how do I do that with a more complex formula?

=sum(#HNR_Istbestand) /sum({<VK.Tätigkeitsliteral={'Technik'}>}[VK.VK-Wert2])

Greetings

Mario

[sunny_talwar · Accepted solution]

This

=Sum({1} #HNR_Istbestand)/Sum({1<VK.Tätigkeitsliteral = {'Technik'}>}[VK.VK-Wert2])

[socura]

I had to know that. One of these days...;-)

Thank You very much!