Hello,
I am using a DirectQuery to pull data onto a table on the report
tblPCodes
----------
pCode perf
xyz 123
gft 67.9
twu 55.31
...
I created banding i.e. range of values to workout he count of pCodes that fall within bands... the measure which does the count of pCodes is called count
This is good so far.
The chart I have created shows the count on y axis and the band on the x axis
All good so far...
Now, I would like to be able to click on the bars in the chart and so the data inside the tblPCodes visual to filter for only those pCodes in that Band. But it does not filter the tblPCodes.
Probably it is to do with the DirectQuery....
In-case it is helpful, the measure that I am using to get the count of the pCodes in tblPCodes is:
count =
COUNTAX(
FILTER(
'Unitised Performance',
[Performance] > SELECTEDVALUE(PerformanceBands[Low]) && [Performance] <= SELECTEDVALUE(PerformanceBands[High])
),
'Unitised Performance'[Portfolio Key]
)
How can I achieve this please?
Thank you
