cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vinicius_ramos
Frequent Visitor

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!

1 ACCEPTED SOLUTION

@vinicius_ramos 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

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

6 REPLIES 6
Greg_Deckler
Super User
Super User

@vinicius_ramos You can use TODAY() or MAXX(ALL('Table'),[Date])


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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?

@vinicius_ramos 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

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

@Greg_Deckler 

 My data table is " Log_bateria[Data]"

 

I used : 

Total Defeito = calculate(
DISTINCTCOUNT(Log_Bateria[Equipamentos]),Log_Bateria[Status1] = "Com Defeito",
Log_Bateria[Data] = MAX(Log_Bateria[Data])) + 0
 
and return to me: A 'MAX' function was used in a True/False expression used as a table filter expression. This is not allowed.
 
Do you can help me?

@vinicius_ramos 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

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Hello, @Greg_Deckler 

 

It's work.

 

Thanks a lot !!! 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.