Urgent help needed with variables

[TechoGirl0]

Hi,

I am an entry level powerBI developer and am trying to simplify this measure using variables. I have never done this with an IF statement. Any help/suggestions would be much appreciated.

MeasureX =

if(

CALCULATE(DISTINCTCOUNT(Program[ProgramStoreProduct]),

FILTER(Program, Program[Non Compliant]=1)

)=BLANK()

,BLANK()

,CALCULATE(DISTINCTCOUNT(Program[ProgramStoreProduct]),

FILTER(Program, Program[Non Compliant]=1)))

[tackytechtom]

Hi @TechoGirl0 ,

Do you mean something like this? 🙂

VAR _v1 =
CALCULATE ( 
    DISTINCTCOUNT ( Program[ProgramStoreProduct] ),
    FILTER ( Program, Program[Non Compliant] = 1 )
)
RETURN
IF ( _v1 = BLANK(), BLANK(), _v1 )

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[daXtreme]

No need for any variables for the above formula. And the simplest (and fastest) version is this:

calculate ( 
    distinctcount ( Program[ProgramStoreProduct] ),
    keepfilters ( Program[Non Compliant] = 1 )
)

By the way, this expression:

IF ( _v1 = BLANK(), BLANK(), _v1 )

is nothing else but simply...

_v1