Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
This seems like it should be easy, but I can't seem to figure it out. Thank you in advance for your help.
Solved! Go to 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] ) ) )
That worked, thanks for the quick reply! How would I modify so that if MatterID is blank, it returns a zero?
Perfect, thanks
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |