Forum Discussion

fonsogijon's avatar
fonsogijon
Frequent Visitor
2 years ago
Solved

Activity Date - Filter Date & Logs

I'm trying to create an activity report in Power BI base on the logs in each data set. My goal is to be able to filter for Date and #Logs.  For example I would like to see the datasets where: The...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi fonsogijon 

     

    Unfortunately that I can not access this link:

    But here I create a set of sample:

    Then add a new table:

    Table = GENERATESERIES(0,COUNTROWS('Activity'),1)

    Then add a slicer:

    And a Measure created:

    MEASURE =
VAR _Slicer =
    MIN ( 'Table'[Value] )
VAR _currentID =
    SELECTEDVALUE ( Activity[DatasetId] )
VAR _Count =
    COUNTROWS (
        FILTER ( ALLSELECTED ( 'Activity' ), 'Activity'[DatasetId] = _currentID )
    )
RETURN
    IF ( _Count >= _Slicer, _Count, BLANK () )

    The result is as follow:

     

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi fonsogijon 

     

    Unfortunately that I can not access this link:

    But here I create a set of sample:

    Then add a new table:

    Table = GENERATESERIES(0,COUNTROWS('Activity'),1)

    Then add a slicer:

    And a Measure created:

    MEASURE =
VAR _Slicer =
    MIN ( 'Table'[Value] )
VAR _currentID =
    SELECTEDVALUE ( Activity[DatasetId] )
VAR _Count =
    COUNTROWS (
        FILTER ( ALLSELECTED ( 'Activity' ), 'Activity'[DatasetId] = _currentID )
    )
RETURN
    IF ( _Count >= _Slicer, _Count, BLANK () )

    The result is as follow:

     

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.