Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I am trying to create a histogram. I have used the field data Quantity_Collected in the data part and it gives me a histogram of all the data points. If I want to limit it to the year 2018 and other criteria such as collection code, how do you do it. i have tried:
Sum({<ColYear={"$(=year(Today()))"}, [Collection Code]-={'Z','D'}>}[Quantity_Collected] It returns invalid dimension
Thanks
Del
what about
Sum({<ColYear={"=year(Today())"}, [Collection Code]-={'Z','D'}>}[Quantity_Collected]
Try this
Sum({$<
ColYear={"=year(Today())"},
[Collection Code]={'*')-{'Z','D'}>}Quantity_Collected)
Or else
create a variable Year(today()) for 2018 and use in an expression.
Try this:
If(ColYear = Year(Today()) and [Collection Code] <> 'Z' and [Collection Code] <>'D', [Quantity_Collected] )
Thanks all for your comments, the only one that does not retun invalid dimension is :
If(ColYear = Year(Today()) and [Collection Code] <> 'Z' and [Collection Code] <>'D', [Quantity_Collected] ) but it returns - The chart is not displayed because it contains only undefined values
May i have your sample data or app? My expression is based on the expression on your post.