Blank and no Blank value

[dofrancis3]

Dear Colleagues;

Please could you help me the fund a solution i'm not expert in DAX:

I have two colomns (Satus and Date):

In the colomn "Status" i would like to count the number of "Pass" AND "Fail" only if in the colomns "Date" the Date is not blank

below is my mesure

Nbr of Status = CALCULATE(COUNTROWS(repository),repository[STATUS]= "Pass"||repository[STATUS]= "Fail")

Thank you for your support

[Anonymous · Accepted solution]

Hi @dofrancis3 ,

If I understand correctly, the issue is that you want to count the number of Pass and Fail. Please try the following methods and check if they can solve your problem:

1.Create the simple Table.

2.Create a new measure to calculate the number. Enter the following DAX formula.

Nbr of Pass and Fail Status = 
CALCULATE(
    COUNTROWS('Table'),
    'Table'[Status] IN {"Pass", "Fail"},
    NOT(ISBLANK('Table'[Date]))
)

3.Move the measure into the card visual.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi,

Please try something like below if it suits your requirement.

Nbr of Status =
CALCULATE (
    COUNTROWS ( repository ),
    ( repository[Status] = "Pass"
        || repository[Status] = "Fail" )
        && repository[Date] <> BLANK ()
)

[dofrancis3]

Dear @Jihwan_Kim thank you for your support it work but i would like to use the same logic to Summarize "sampled" colomn only if the "date" is not blank 

Be low my mesure

Tot_sampled =

VAR __numberOfInterwd = SUM(LQASrepository[Total sampled),

                                            && LQASrepository[Start date] <> BLANK ())

RETURN

IF(ISBLANK(__numberOfInterwd), "No Data",__numberOfInterwd)

Please support