Forum Discussion
Helper IAggregate string into groupings based on filter selection
Hi jos818
In the query editor, I would add an index column which will serve as a reference to the original rows prior to adding a column that splits diagnosis into several rows for each semicolon
The steps above will result to the table below.
Notice that index 11 repeats 3x so the measure to total the views should take this into consideration.
Total Views = SUMX ( VALUES ( 'Table'[Index] ), CALCULATE ( MAX ( 'Table'[Daily views] ) ) )Please see the attached pbix.
Hi jos818,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well.
And if you're still looking for guidance, feel free to give us an update, we’re here for you.
Best Regards,
Hammad.
Hi jos818,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.
Best Regards,
Hammad.
Hi jos818,
We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.Best Regards,
Hammad.