Forum Discussion

Faber13's avatar
Faber13
Helper II
3 years ago
Solved

TABLE WITH LAST REGISTRATION

Guys, I have a table with records of invoices that are repeated over time, I need to make a distinct count only of the most recent date of the records, ignoring the rest. I believe the value is wrong because we have repeated data in different periods

 

 

Need Help
Show and Tell

4 Replies

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Faber13 ,

    which measure have you used in the wrong card?

    I think if you use the function DISTINCTCOUNT('Table'[InvoiceNumber]) it works and then filter the most recent days with CALCULATE .

     

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

    • Faber13's avatar
      Faber13
      Helper II
      3 years ago

      hi mangaus1111  it's the same measure, it changes in the graph's filter context (for example: the same invoice can be at the beginning and at the end of the month)

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Faber13 ,

        You can create a measure as below to get it:

        Measure =
VAR _maxdate =
    CALCULATE ( MAX ( 'table'[date] ), ALLSELECTED ( 'table' ) )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'table'[invoice number] ),
        FILTER ( ALLSELECTED ( 'table' ), 'table'[date] = _maxdate )
    )

        If the above one can't help you get the expected result, could you please provide some sample data in your tables (exclude sensitive data) with Text format, the formula of measure which apply on the card visual and visual settings. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

        How to upload PBI in Community

        Best Regards