Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a measure, and I would like to show all values, if not have a value for some filters, show 0, but always show all values for dimension fieldB.
Dimension= fieldB
measure= count ({<flag={1}>} distinct fieldA &'|' & fiedlB)
Try this:
measure= count ({<flag={1},fiedlB>} distinct fieldA &'|' & fiedlB)
first of all, thank you for your answer, but not working.
Its shows only 1 line of fieldB if a filter for example FilterC
Yes sorry, I've done the opposite of you want, try this, this makes the expression insensible to whatever selections except for fieldB:
count ({1<flag={1},fieldB=p(fieldB)>} distinct fieldA &'|' & fieldB)
sorry, I will try explain better.
I want to select all filters, and all fields, and reflect this in the value.
For example:
FilterC = its country
I would like to filter the country, and the quantity ( count distinct fieldB will change ) but I would like to keep showing all values to fieldB. If not have a country selected, show 0 instead of suppress the fieldB. So I can't ignore all selections
Try:
Measure = "Your Measure " + 0*Count({1}Field_1)
I think its works, let me check
Try using Include Zero Values From Add ons in table