Forum Discussion
Create a measure
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(CredP...
Shahid12523
Community Champion
Community ChampionUse this
Utilization =
CALCULATE (
SUM ( CredPortfolio_dataset[Book Value MZ] ),
ALLEXCEPT (
CredPortfolio_dataset,
CredPortfolio_dataset[Industrial Sector (Eng)],
CredPortfolio_dataset[Reporting Year/Month]
)
)