Calculate cost based on category from different table

Hi zzzsharepointk,

You can create a new table with time series and non-time series two types. Then you can extract the current type and add switch in your formula to calculated with different fields based on the type values.(you can add new table field to table visual 'visual level filter' to filter records)

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup.com)

formual =
VAR currType =
    SELECTEDVALUE ( NewTable[Type] )
RETURN
    CALCULATE (
        SWITCH (
            currType,
            "timeseries", MAX ( Table2[Blow ratio] ),
            "non-timeseries", MAX ( Table2[Non-Blow ratio] )
        ),
        ALLSELECTED ( Table2 ),
        VALUES ( Table2[Cluster] ),
        VALUES ( Table2[Projects] )
    )
        * CALCULATE (
            SUM ( Table1[Cost] ),
            ALLSELECTED ( Table1 ),
            VALUES ( Table2[Cluster] ),
            VALUES ( Table1[Category] )
        )

Regards,

Xiaoxin Sheng