Dax expression with 2 part filter: one numeric field and one category type field

[22LACMT]

Hi,  im trying create a column that sums exposure by category type( jared roll-up) and ver.  I'm having trouble finding a funtion that allows for two filters.  I've tried to use the calculate funtion but it doesnt allow for a sum and two filters.  Any suggestions? below is sample data. 

[v-yiruan-msft · Accepted solution]

Hi @22LACMT ,

You can create a similar measure as the below one:

Measure =
CALCULATE (
    SUM ( 'tablename'[Tier1Exposure] ),
    FILTER (
        'tablename',
        'tablename'[LoanDisclosure_JaredRollup] = "Permanent"
            && 'tablename'[ver] = DATE ( 2020, 12, 31 )
    )
)

In addition, you can refer the following blog to create it by yourself:

FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations

If the above ones can't help you get the desired result, please provide some sample data in your table  (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[amitchandak]

@22LACMT ,

Not very clear

You can have measure like

calculate(Sum(Table[Value]), filter(Table, Table[Number] = 1.2 && table[column] = "ABC"))

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[AlexisOlson]

CALCULATE can definitely handle multiple filters. For example,

CALCULATE (
    SUM ( Table1[Exposure] ),
    Table1[JaredRollup] = "Permanent",
    Table1[ver] = 3
)