Forum Discussion
rpiboy_1
3 years agoHelper V
Dynamic Data Segmentation
First off, I've reviewed the various posts by RADACAD, Enterprise DNA and SQLBI on this topic. I have measures based on RADACAD & SQLBI all working, but its not giving me what I need/want. I ...
FreemanZ
3 years agoSuper User
hi rpiboy_1
try like:
Measure =
VAR _count = ['Count Report Runs']
RETURN
MINX(
FILTER(
RunSegments,
RunSegments[Min]<=_count
&&RunSegments[Max]>=_count
),
RunSegments[SegmentName]
)
rpiboy_1
3 years agoHelper V
FreemanZ thanks, that seems to work in a limited manner, now I'll have to compare it to what I was trying to do so I can understand it.
However, I can't seem to filter the table visual showing Report Name & Segement name so that I'm only looking at a list of Reports that are in the mid segement for instance... Any thoughts?
Thanks!