Blank if Count is same on the other days within the week

[AllanBerces]

Hi Good day can anyone help me edit my caculated column. What i required is if the count on column Count/DirectInDirect/Location is same on the other day with the week then the WKLY POB PLAN will show blank on the other day.

WKLY POB PLAN =

VAR _currentWeek = 'Table'[Week No:]

VAR _currentCode = 'Table'[Location]

VAR _DirecIndirect = 'Table'[Direct/InDirect]

VAR _FilteredTable =

    FILTER (

        'Table',

        'Table'[Week No:] = _currentWeek
            && 'Table'[Location] = _currentCode

            && 'Table'[Direct/InDirect] = _DirecIndirect

    )

RETURN

    IF (

        MAXX ( _FilteredTable, [Count/DirectInDirect/Location] ) = 'Table'[Count/DirectInDirect/Location],

        'Table'[Count/DirectInDirect/Location]

    )

DESIRED OUTPUT

Date	Trade	Location	Direct/InDirect	Week No:	Count/DirectInDirect/Location	WKLY POB PLAN
2/15/2026	Mech	North	InDirect	7	12	12
2/15/2026	Mech	North	Direct	7	12	12
2/15/2026	Mech	North	Direct	7	12	12
2/15/2026	Mech	North	Direct	7	12	12
2/15/2026	Mech	North	Direct	7	12	12
2/15/2026	Civil	North	InDirect	7	12	12
2/15/2026	Civil	North	Direct	7	12	12
2/15/2026	Civil	North	Direct	7	12	12
2/15/2026	Civil	North	Direct	7	12	12
2/15/2026	Civil	North	Direct	7	12	12
2/15/2026	Mech	North	Direct	7	12	12
2/15/2026	Mech	North	Direct	7	12	12
2/11/2026	Civil	South	InDirect	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/11/2026	Civil	South	Direct	7	15	15
2/12/2026	Civil	South	InDirect	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15
2/12/2026	Civil	South	Direct	7	15

[FBergamaschi · Accepted solution]

Hi @AllanBerces,

I created this code that seems to work

WKLY POB PLAN 2 =

VAR _currentWeek = 'Table'[Week No:]

VAR _currentCode = 'Table'[Location]

VAR _DirecIndirect = 'Table'[Direct/InDirect]

VAR _FilteredTable =

    FILTER (

        'Table',

        'Table'[Week No:] = _currentWeek

            && 'Table'[Location] = _currentCode

            && 'Table'[Direct/InDirect] = _DirecIndirect

    )

RETURN

    IF (

        MAXX ( _FilteredTable, [Count/DirectInDirect/Location] ) = 'Table'[Count/DirectInDirect/Location] && MINX ( _FilteredTable, 'Table'[Date] ) = 'Table'[Date],

        'Table'[Count/DirectInDirect/Location]

    )

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Praful_Potphode · Accepted solution]

Hi @AllanBerces 

try attached PBIX.

if this doesnt work please help with sample explanation for few rows.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[v-ssriganesh]

Hi @AllanBerces,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Irwan, @Praful_Potphode & @FBergamaschi for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[Praful_Potphode · Accepted solution]

Hi @AllanBerces 

try attached PBIX.

if this doesnt work please help with sample explanation for few rows.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[Irwan]

hello @AllanBerces 

please check if this accomodate your need.

create a new calculated column with following DAX.

WKLY POB PLAN =
var _Yearweek = YEAR('Table'[Date])&FORMAT(WEEKNUM('Table'[Date]),"00")
var _Mindate = 
MINX(
    FILTER(
        'Table',
        YEAR('Table'[Date])&FORMAT(WEEKNUM('Table'[Date]),"00")=_Yearweek
    ),
    'Table'[Date]
)
var _IF = 
IF(
    _Mindate='Table'[Date],
    _Mindate
)
Return
MINX(
    FILTER(
        'Table',
        'Table'[Date]=_IF
    ),
    'Table'[Count/DirectInDirect/Location]
)

Hope this will help.

Thank you.

[AllanBerces]

Hi @Irwan thank you for the reply but its not giving the required i need.

[Irwan]

hello @AllanBerces 

can you share what kind of data that does not return right?
Thank you.

[AllanBerces]

Hi @Irwan the location is different it should be 15

Date TradeLocationDirect/InDirectWeek No:Count/DirectInDirect/LocationWKLY POB PLAN_rev2/15/2026 MICOInDirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/15/2026 MICOInDirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/15/2026 MICODirect712122/11/2026 SMSDInDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/11/2026 SMSDDirect715 2/12/2026 SMSDInDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/12/2026 SMSDDirect715 2/15/2026 SMSDInDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect715122/15/2026 SMSDDirect71512

[Irwan · Accepted solution]

hello @AllanBerces 

what is your DAX in there?

seems different from my result.. there should be a value on 2/11/2026 while your screenshot show blank.

also for the bottom highlight, please adjust the DAX into this (the red one). I dont realize there will be a different 'Table'[Count/DirectInDirect/Location] value in same date.

WKLY POB PLAN =
var _Yearweek = YEAR('Table'[Date])&FORMAT(WEEKNUM('Table'[Date]),"00")
var _Mindate = 
MINX(
    FILTER(
        'Table',
        YEAR('Table'[Date])&FORMAT(WEEKNUM('Table'[Date]),"00")=_Yearweek
    ),
    'Table'[Date]
)
var _IF = 
IF(
    _Mindate='Table'[Date],
    _Mindate
)
Return
IF(
    'Table'[Date]=_Mindate,
    'Table'[Count/DirectInDirect/Location]
)

Thank you.

[FBergamaschi · Accepted solution]

Hi @AllanBerces,

I created this code that seems to work

WKLY POB PLAN 2 =

VAR _currentWeek = 'Table'[Week No:]

VAR _currentCode = 'Table'[Location]

VAR _DirecIndirect = 'Table'[Direct/InDirect]

VAR _FilteredTable =

    FILTER (

        'Table',

        'Table'[Week No:] = _currentWeek

            && 'Table'[Location] = _currentCode

            && 'Table'[Direct/InDirect] = _DirecIndirect

    )

RETURN

    IF (

        MAXX ( _FilteredTable, [Count/DirectInDirect/Location] ) = 'Table'[Count/DirectInDirect/Location] && MINX ( _FilteredTable, 'Table'[Date] ) = 'Table'[Date],

        'Table'[Count/DirectInDirect/Location]

    )

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[AllanBerces]

Hi @FBergamaschi @Praful_Potphode @Irwan @v-ssriganesh thank you very much for the reply, work as i need