Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to filter a grouped table by filtering the base table

Hello! I have a table 1 consisting of different user actions types. I need to count how freequently different users do actions in the same subsequence.  1) I made a table 2 with unique customers a...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello! 

 


https://app.powerbi.com/groups/me/reports/f6bdda21-518d-4f1c-9be0-616af7ac0423?ctid=21f92996-c72d-4b9f-b5a5-283c00b9ecaa&pbi_source=linkShare
https://playground.powerbi.com/ru-ru/dev-sandbox?reportId=f6bdda21-518d-4f1c-9be0-616af7ac0423

I belive achieving my first idea is imposible, since it requires PBI to reconcatine "paths" every time you filter the date, because some actions will be filtered from users paths. With real data it seems unrealistic (>10.000 rows, i cant even concatinate it, its just loading, I'm making two sql requests).  So the best thing I came up with is filtering it backwards, clicking on the last table, then on the id in the second table to see the action with date an so on.
If you have a better idea about it, Ill be very thankful. The main idea is research dependency between dates and paths.


  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

    I can create a measure to show the path based on the current id group and date filter, but I can't achieve the third one.

    path fromula =
IF (
    HASONEVALUE ( 'Table'[ID] ),
    CONCATENATEX ( VALUES ( 'Table'[Actions] ), [Actions], "->" )
)

    CONCATENATEX function (DAX) - DAX | Microsoft Docs


    Current measure expression does not work as group fields to expand other calculation aggregations. Calculation columns can be worked as groups but it not able to dynamically change based on filters. (they are working on different levels)

    Notice: the data level of power bi.

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng