Forum Discussion

Fighaz's avatar
Fighaz
New Member
1 year ago

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(CredPortfolio_dataset[Book Value MZ]),
    'CredPortfolio_dataset'[Industrial Sector (Eng)],CredPortfolio_dataset[Reporting Year/Month]
)
Learn Together

1 Reply

  • Shahid12523's avatar
    Shahid12523
    Icon for Community Champion rankCommunity Champion
    1 year ago

    Use this

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