Get a count from nested if statement

[tastydew]

I have the following nested if statement to count specific items in a table...

if(if([Status]='Completed',Count([Req #]))=1,Count([Req #]))

How can I get a count of the results it returned?

[Vegar]

Try to put sum() around your expression.
SUM( if(if([Status]='Completed',Count([Req #]))=1,Count([Req #])) )

[tastydew]

I am unable to do this because it would be nested aggregation

[Vegar]

I see. SET analysis might be the way to go. Try something like this:

Count( {$<[Req #] = {“=Count({<Status={'Completed'}>}[Req #]) = 1”}>} [Req #] )

[MynhardtBurger]

I am correct in saying your existing measure...

if(
    if(
        [Status]='Completed',
        Count([Req #])
    ) = 1,
    Count([Req #])
)

be restated like so:

if(
    Count({<[Status]={'Completed'}>} [Req #]) = 1,
    Count([Req #])
)

Now you want to count the results which that returns.

So, like Vegar suggested, you should be able to get the count of the results by wrapping it in a sum:

Sum( Count({<[Status]={'Completed'}>} [Req #]) = 1 ) * -1

The numerical representation of TRUE() is '-1', and FALSE() is '0'. So you can sum the true values and multiply by -1 to get the count.

[Vegar]

I think you @MynhardtBurger will get trouble with the nested aggregations sum(count()) as @tastydew wrote earlier.

[tastydew]

I still get the following:

[MynhardtBurger]

Sum(
	aggr(
	    count({<[Status]={'Completed'}>} [Req #]) = 1,
    	    [Req #]
	)
) * -1