How do I get the current date from totalling

[EaglesTony]

hi,

  I have a measure called "Current Date", which is todays date.

  When I put in in a table with records from another table, it give me a total line under the Current Date:

[V-yubandi-msft · Accepted solution]

Hi @EaglesTony ,

Thank you for engaging with the Microsoft Fabric Community. The reason you're seeing a total line under the  Current Date column is because it's a measure that returns the same value ( Today() or NOW()), and Power BI automatically includes this in the total row of the visual. Since it's not an aggregated value (like SUM or AVERAGE),

Go to the Format pane → Totals → Disable Totals for Current Date to prevent any unwanted aggregations.

FYI:

When Total-Values is OFF

FYI:

When Total-Values is ON

For more details, please review the attached PBIX file.


If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[ToddChitt]

What are you expecting to see? What's the problem you're trying to solve?