Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
coming from Power BI, I still find it a little difficult to adapt to conditional measures in QS. I have several questions:
My examples are obviously made up - I am more interested in the general concept / syntax.
Thanks a lot in advance, guys - that would help my understanding of conditional measures in QS.
Best
T
1. The simplest way to do this is to just select ProductGroup='A', by clicking on this field value, and then look at the measure value. Selections work globally, so you don't need to hard code them.
However, if you want to hard code the filter into the measure definition, I must unfortunately say that it is not possible, unless you change the definitions of Revenue and Costs. We are however aware of the limitation and are looking into possible solutions.
2. Just use "{<ProductGroup='A', Year=>}" and you will cancel the selection in Year.
3. This can be achieved by using a set expression in the denominator only: "Sum(Revenue) / Count({1} distinct total Product)". The "{1}" will make the denominator insensitive to your selection, and the "total" will make it insensitive to the dimension in the chart (it will return the total in the chart, and not the value for the specific dimensional value).
HIC