Create a measure

[Fighaz]

Hi, need help to create a measure where I sum a column and filter by sector wise as well as reporting year/month as per below and it seemes not correct:

_Utilization =

CALCULATE(

    SUM(CredPortfolio_dataset[Book Value MZ]),

    'CredPortfolio_dataset'[Industrial Sector (Eng)],CredPortfolio_dataset[Reporting Year/Month]

)

[Shahid12523]

Use this

Utilization =
CALCULATE (
SUM ( CredPortfolio_dataset[Book Value MZ] ),
ALLEXCEPT (
CredPortfolio_dataset,
CredPortfolio_dataset[Industrial Sector (Eng)],
CredPortfolio_dataset[Reporting Year/Month]
)
)