Forum Discussion

RichardT_78's avatar
RichardT_78
Helper I
3 years ago
Solved

Controlling Individual matrix row data using a date column

  How would i use the amended time stamp to influence what i saw on a row level So, i want to only see everything after the amended date   Typically for car A the counts were reduce greatly...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, RichardT_78 

     

    You can try the following methods.

    Measure =
CALCULATE ( COUNT ( 'Table'[Event description] ),
    FILTER ( ALL ( 'Table' ),
        [Date] > SELECTEDVALUE ( 'Table'[Ammended time stamp] )
            && [Car] = SELECTEDVALUE ( 'Table'[Car] )
            && [Event description] = SELECTEDVALUE ( 'Table'[Event description] )
    )
)

    Is this the result you expect? If not, simplify your data and give examples of your desired results.

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, RichardT_78 

 

You can try the following methods.

Measure =
CALCULATE ( COUNT ( 'Table'[Event description] ),
    FILTER ( ALL ( 'Table' ),
        [Date] > SELECTEDVALUE ( 'Table'[Ammended time stamp] )
            && [Car] = SELECTEDVALUE ( 'Table'[Car] )
            && [Event description] = SELECTEDVALUE ( 'Table'[Event description] )
    )
)

Is this the result you expect? If not, simplify your data and give examples of your desired results.

 

Best Regards,

Community Support Team _Charlotte

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