Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Trying to write a formula
Could you correct this?
if(GetSelectedCount({<[Product Sub Group]>}={'Cheese'}>}[Sales]))
I only want the chart to populate if cheese is selected
Thankyou
In the calculated condition
if( [Product Sub Group] = 'Cheese', -1, 0 )
So, right now since nothing is selected, the expression doesn't show anything... isn't that what you want? Or would you want to see Cheese even if nothing is selected? For this you can try this
Sum({<[Product Sub Group] *= {'Cheese'}>}[Sales Amount])
I want the chart to show me the count of sales only when cheese the value is selected, but when it is not it shows all values
So if Cheese and Beer is selected... it should not show anything?
If([Product Sub Group] = 'Cheese', Sum([Sales Amount]))
Hi,
Maybe like this:
If([Product Sub Group] = 'Cheese', Sum([Sales Amount]),Sum({1}[Sales Amount]))