Select value from a column based on a criteria from another column

[tim_001]

Hi, 

I tried to find a solution but did not really find what I need. 

Database Table: 

Contract Type	Year	Customer
Contract	2025	Alex
No Contract	2026	Alex
Contract	2025	Tim
Contract	2026	Tim

Measure for visual: 

--> What contract does Alex and Tim have in year 2026?

I am thinking a custom column that only considers the data in Year 2026 and if it is not 2026 make it blank. Or a measure that can just find the Contract Type in Year 2026. 

I am thankful for any ideas. I might be just stuck in my head and there is a simple solution for it... 

Kind Regards

[v-hjannapu]

Hi @tim_001,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to @MasonMA  , for those inputs on this thread. 
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Thank you

[v-hjannapu]

Hi @tim_001,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.

Regards,
Harshitha.

[MasonMA]

@tim_001 

Hi, in case there are multiple Contract types to handle for same Year,

you may need to try below Measure

Contracts_2026 = 
CALCULATE(
    CONCATENATEX(
        VALUES('Table'[Contract Type]),
        'Table'[Contract Type],
        ", "
    ),
    'Table'[Year] = 2026
)

 so you will get result like below

[wardy912 · Accepted solution]

Hi @tim_001 

I'll give both options, measure and calculated column, both only showing the 2026 data.

Measure:

ContractType_2026 = 
CALCULATE(
    SELECTEDVALUE('Table'[Contract Type]),
    'Table'[Year] = 2026
)

Calculated column:

ContractType_2026_Column = 
IF('Table'[Year] = 2026, 'Table'[Contract Type], BLANK())

Please give a thumbs up and mark as solved if this helps, thanks!