Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ValeriaBreve
Post Patron
Post Patron

Need to ignore dates in chart via measure

Hello,

I have a measure that is supposed to render the max value from a calculation. It works as such, but as soon as I put it in a chart with a few columns from the Date_Table, it gets sliced accordingly even though I have removed the filtering in DAX.
There is a relationship between Date_Table[Date] 1--> * 'Experimental Sample Req'[Created]

Can somebody put me in the right path on how to have the measure return the same value (max) everywhere? I am at a loss. Thanks!
Kind regards
Valeria

VAR SamplesTable =
SUMMARIZECOLUMNS(
'Experimental Sample Req'[Id],
FILTER(
'Experimental Sample Req',
'Experimental Sample Req'[Status] = "COMPLETED"
),

"Date Created", MAX( 'Experimental Sample Req'[Created] ),
"Ready for Scheduling Date",
MAX(
'Experimental Sample Req'[Ready_for_Scheduling_Set_Date]
),
"Created to Ready to Schedule",
DATEDIFF(
MAX( 'Experimental Sample Req'[Created] ),
MAX(
'Experimental Sample Req'[Ready_for_Scheduling_Set_Date]
),
DAY
),
"Production Date",
MAX( 'Experimental Sample Req'[Production_Date] ),
"Ready to Schedule to Production",
DATEDIFF(
MAX(
'Experimental Sample Req'[Ready_for_Scheduling_Set_Date]
),
MAX( 'Experimental Sample Req'[Production_Date] ),
DAY
),
"First Goods Issue",
MAX( 'Experimental Sample Req Volume'[Goods_Issue_Date] ),
"Production to Goods Issue",
DATEDIFF(
MAX( 'Experimental Sample Req'[Production_Date] ),
MAX( 'Experimental Sample Req'[Goods_Issue_Date] ),
DAY
),
"Status", MAX( 'Experimental Sample Req'[Status] )
)
RETURN
{
CALCULATE(
MAXX( SamplesTable, [Ready to Schedule to Production] ),
ALL( 'Experimental Sample Req' ),
REMOVEFILTERS( Date_Table ),
ALL(Date_Table),
CROSSFILTER( Date_Table[Date], 'Experimental Sample Req'[Created], None )
)
}

1 ACCEPTED SOLUTION
wardy912
Resolver IV
Resolver IV

Hi @ValeriaBreve 

 

The relationship between the date table and 'experimental sample req' needs to be ignored in the measure, ALL inside the FILTER ensures no other filters affect the data.

 

Max_ReadyToScheduleToProduction :=
VAR SamplesTable =
    SUMMARIZE(
        FILTER(
            ALL('Experimental Sample Req'),
            'Experimental Sample Req'[Status] = "COMPLETED"
        ),
        'Experimental Sample Req'[Id],
        "ReadyToScheduleToProduction", 
            DATEDIFF(
                MAX('Experimental Sample Req'[Ready_for_Scheduling_Set_Date]),
                MAX('Experimental Sample Req'[Production_Date]),
                DAY
            )
    )
RETURN
    MAXX(SamplesTable, [ReadyToScheduleToProduction])

 

If this helps please give a thumbs up, thanks!

View solution in original post

2 REPLIES 2
ValeriaBreve
Post Patron
Post Patron

@wardy912 Thank you!!!!

wardy912
Resolver IV
Resolver IV

Hi @ValeriaBreve 

 

The relationship between the date table and 'experimental sample req' needs to be ignored in the measure, ALL inside the FILTER ensures no other filters affect the data.

 

Max_ReadyToScheduleToProduction :=
VAR SamplesTable =
    SUMMARIZE(
        FILTER(
            ALL('Experimental Sample Req'),
            'Experimental Sample Req'[Status] = "COMPLETED"
        ),
        'Experimental Sample Req'[Id],
        "ReadyToScheduleToProduction", 
            DATEDIFF(
                MAX('Experimental Sample Req'[Ready_for_Scheduling_Set_Date]),
                MAX('Experimental Sample Req'[Production_Date]),
                DAY
            )
    )
RETURN
    MAXX(SamplesTable, [ReadyToScheduleToProduction])

 

If this helps please give a thumbs up, thanks!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.