topic Re: Blank and no Blank value in DAX Commands and Tips

Blank and no Blank value

dofrancis3 — Fri, 09 Feb 2024 01:06:29 GMT

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

Re: Blank and no Blank value

Jihwan_Kim — Fri, 09 Feb 2024 03:36:48 GMT

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 () )

Re: Blank and no Blank value

dofrancis3 — Sat, 10 Feb 2024 12:57:46 GMT

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

Re: Blank and no Blank value

Anonymous — Mon, 12 Feb 2024 08:59:11 GMT

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.