Forum Discussion

sgajjar's avatar
sgajjar
Frequent Visitor
1 year ago
Solved

Issue with Measure in Table1 Breaking When Adding DateTime Column to Table2 in Power BI

Hello Power BI Community, I am encountering an issue with a measure from Table1 when I try to use it in Table2. I have a table (Table1) with a measure that works fine, and I want to use that...
Need Help
  • sgajjar's avatar
    sgajjar
    1 year ago

    Thanks, this helped. Eventually had to replace all measures with columns on existing table and had to use removefilters for datatime column. that fixed the context issue. 

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi sgajjar 

  • Adding a DateTime column can alter row context, breaking measures due to filter propagation.

  • The DateTime column introduces finer granularity, changing row context and impacting the measure's evaluation.

  • To resolve without removing the DateTime column, use CALCULATE with REMOVEFILTERS or aggregate the DateTime column to reduce granularity
    If this post helped please do give a kudos and accept this as a solution
    Thanks In Advance

  • sgajjar's avatar
    sgajjar
    Frequent Visitor
    1 year ago

    Thanks, this helped. Eventually had to replace all measures with columns on existing table and had to use removefilters for datatime column. that fixed the context issue.