Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jl20
Helper IV
Helper IV

Calculated Column akin to COUNTIF

Hi,

 

I am trying to figure out a formula for a calculated column that will count the number of instances of a MatterID number (i.e., the red text in the screenshot below). Every "D" is on the table one time. Then, if the job becomes active, a new "E" record is created with the same MatterID. I searched the forum and could only find examples where multiple tables were involved.COUNTIF.JPG

 

This seems like it should be easy, but I can't seem to figure it out. Thank you in advance for your help.

1 ACCEPTED SOLUTION

To handle that, just wrap the original measure in an IF ISBLANK test:

 

=
IF (
    ISBLANK ( YourTable[MatterID] ),
    0,
    CALCULATE (
        COUNTROWS ( YourTable ),
        ALLEXCEPT ( YourTable, YourTable[MatterID] )
    )
)

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

4 REPLIES 4
OwenAuger
Super User
Super User

@jl20

A calculated column like this should to the trick:

 

=
CALCULATE ( 
    COUNTROWS ( YourTable ),
    ALLEXCEPT ( YourTable, YourTable[MatterID] )
)

Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

That worked, thanks for the quick reply! How would I modify so that if MatterID is blank, it returns a zero?

To handle that, just wrap the original measure in an IF ISBLANK test:

 

=
IF (
    ISBLANK ( YourTable[MatterID] ),
    0,
    CALCULATE (
        COUNTROWS ( YourTable ),
        ALLEXCEPT ( YourTable, YourTable[MatterID] )
    )
)

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Perfect, thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.