Count Distinct in an overdue balance aging

[ugurarslan]

Dear all,

please see the table as following:

	Aging Bucket
Company ID	1-60	61-90	90 - 120	120+
Apple	$13	$50		$6
Peer	$8	$9	$150	$50
Banana	$5			$9
PineApple		$5
Bag	$7		$8	$8
Table		$3

Dimension = Aging Bucket.

If I want to count how many company ID's have an overdue balance of 90 days I write this expression:

Count({<[Aging Bucket]={'90-120'}+{'120+'}>}distinct [Company ID])

Result = 6

But the result needs to be 4 Companies have an item on 90+.

Can you please help me writing the right expression?

Thanks

Ugur

[adityaakshaya]

Hi Ugur,

Please try like below.

Count({<[Aging Bucket]={'90-120','120+'}>}distinct [Company ID])

This will work for you.

Regards,

Akshaya

PS - If you find response Correct/Helpful then mark it as Correct/Helpful.