Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Card last date

Hello friends, 

 

I need to do a card (measure), which updates every day with the current date independent to have a date filter on report.

 

in short, I need to make a measure with the last date and that is not dependent on a filter in the report.

 

Can someone help me?

 

Thanks a lot!

Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Hence why I did not recommend having MAX in your CALCULATE and instead use a separate measure. You can also do this:

    Total Defeito = 
VAR __Max = MAX(Log_Bateria[Data])
RETURN
calculate(
DISTINCTCOUNT(Log_Bateria[Equipamentos]),Log_Bateria[Status1] = "Com Defeito",
Log_Bateria[Data] = __Max) + 0

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello, Greg_Deckler 

       

      I have this measure: 

      Total Defeito = CALCULATE(
      DISTINCTCOUNT(Log_Bateria[Equipamentos]),Log_Bateria[Status1] = "Com Defeito") + 0.
       
      Where i include MAXX(ALL('Table'),[Date]) in this case?
      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        Anonymous Just create a new measure with that formula. Then you could adjust your formula to be something like:

        Total Defeito = CALCULATE(
DISTINCTCOUNT(Log_Bateria[Equipamentos]),Log_Bateria[Status1] = "Com Defeito", 'Table'[Date]=[Max date measure]) + 0