Usung a measure

CALCULATE ( 
            SUM ( Table[cost]),

             Table[Type] = "Underactive",
             Table[dept]= "Claim",
             Table[reason] = "Write off"
)

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Hi gra_197 ,

Thanks for reaching out to the Microsoft fabric community forum.

I’ve revalidated your updated requirement, and you’re absolutely right  the original measure shared above works perfectly to calculate the sum of cost where Type = "Underactive", dept = "Claim" and reason = "Write off". To also include the count of rows matching the same filters, I created a second measure using COUNTROWS inside the same filter logic.

Here’s the additiona measure:

Row Count Measure =
CALCULATE (
COUNTROWS ( 'DataTable' ),
'DataTable'[Type] = "Underactive",
'DataTable'[dept] = "Claim",
'DataTable'[reason] = "Write off"
)

With this, you’ll get two outputs side-by-side  one for the total cost (which returns 350 in the sample data) and the other showing the number of matching records (which is 2 in this case). This way, your full requirement is completely handled. Let me know if you’d like to display both values in the same visual or combine the logic in a more dynamic format

Please find the attached pbix file for your reference.

Best Regards,

Tejaswi.

Community Support