Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I have a table of error logs streaming in within one table. I want to be able to click on a row within the table vis then drill through to the previous 50 entries (although I'd like to be able to adjust the number of entries within a parameter if possible) in another page.
So far I've tried indexing the column, selecting one (e.g RowID: 100) then creating a SelectedIndexMin (50) and SelectedIndexMax (100) field then created a WithinRange flag field (using an if statement) back into the original "Messages" table. I was hoping to drill down on the WithinRange field to take those 50 row ids through to another page, so far no good as the WithinRange shows a 1 for everything.
WithinRange = IF(AND(Messages[RowID]<=[SelectedIndexMax]
,Messages[RowID]>=[SelectedIndexMin])
,1
,0)
Any help would be greatly appreciated.
Cheers,
Chris.
@Anonymous,
Values in a calculated column are fixed. They are an immutable result for each row in the table.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |