topic Re: set analysis in App Development

set analysis

Tool_Tip — Thu, 04 Dec 2025 08:00:57 GMT

Dear experts

How to rewrite below measure expression using set analysis only without using IF

Count(
DISTINCT
If(
[START_DATE] <= '$(vMonthEndTest)'
and [status] = 0
and (
[IsActive] =1
or [END_DATE] >= '$(vMonthStart)'
),
ID
)
)

Re: set analysis

marcus_sommer — Thu, 04 Dec 2025 08:13:38 GMT

You may try something like this:

Count({< [START_DATE] = {"<= '$(vMonthEndTest)'"}, [status] = {0} > *
(< [IsActive] = {1} > + < [END_DATE] = {">= '$(vMonthStart)'"}>) } DISTINCT ID)

Re: set analysis

Nagaraju_KCS — Fri, 05 Dec 2025 05:17:36 GMT

Try this

Count(

DISTINCT{<START_DATE = {"<= $(vMonthEndTest)"},status = {0},ID = {<IsActive = {1}>

<END_DATE = {">= $(vMonthStart)"}>}>}ID)

Re: set analysis

Chanty4u — Thu, 04 Dec 2025 16:10:03 GMT

Try this

Count(

DISTINCT

{

START_DATE = {"<= $(vMonthEndTest)"},

status = {0},

IsActive = {1} + END_DATE = {">= $(vMonthStart)"}

}

)

Re: set analysis

Tool_Tip — Fri, 05 Dec 2025 04:40:13 GMT

Dear all

Thank u for your response but none of the above solution works for me

Re: set analysis

Lech_Miszkiewicz — Fri, 05 Dec 2025 06:02:13 GMT

Hi @Tool_Tip

Looking at the logic of the expression I think @marcus_sommer gave you correct answer as his set analysis replicates logical conditions. Make sure you have those parenthesis in right spot to give proper precedence for * and + on sets as Marcus did.

Also very helpful would be outcome with those fields in straight table and your IF() statement measure next to set analysis equivalent. That is usual way of spotting a difference and seeing where things go wrong. Obviously we dont have that visibility so at least you may have a hint regarding scenarios where this is not working.

We also dont know your data model. So depending on relationships on data you may get different results. It would be helpful to understand where all the fields you use in your expression are in your data model and how they are associated as that may play role too.

My suspicion is that your IF statement does the row level condition and when using set analysis we are working wit set operations on datasets.

cheers