How to count number of row with no product info ?

[admin11]

Hi All

With the help from @v-yingjl i got the below expression working fine :-

flag no product offer yingil = 'CRM_TS'[Product Offer] = ""

Now i need count total how many row not fill with product offer by SBU.

I have try Below , i get error :-

CNT_NO_PROD_INFO = Distinctcount('CRM_TS'[Product Offer] = "")

Below link is my PBI file

https://www.dropbox.com/s/yjan8gv6l4263hw/PBT_V2021_400%20CRM_TS%201%20FILE%20ONLY_1.pbix?dl=0

Paul

[MintuBaruah]

Hello @admin11 

Looking at the data, you can calculate the blank rows in the Product offer column using the below formulae.

CNT_NO_PROD_INFO =

CALCULATE(COUNTROWS(CRM_TS), FILTER(CRM_TS, ISBLANK([Product Offer]) = TRUE()))

This will count total how many rows are not filled with product offers.

Regards,

Mintu Baruah

[admin11]

@MintuBaruah 

I have try to vreate both column and measure , but it display Blank.

Paul

[MintuBaruah · Accepted solution]

Hello @admin11 

It seems to be like the data in the Product info column is not blank when we try with the previous formula. So for that, you have to create a new calculated column

ISBlank =

IF(ISBLANK('CRM_TS'[Product Offer]) || 'CRM_TS'[Product Offer] = "", true(), false())

Next, use the below formula for your card visualization:

CNT_NO_PROD_INFO =

CALCULATE(COUNTROWS(CRM_TS), FILTER(CRM_TS, [ISBlank] = True))

This is working on my side(refer to screenshot):

And if you find the solution useful please mark my post as a solution!
In doing so, you are also helping me.

Thank you!

Mintu Baruah 

[admin11]

@MintuBaruah 

Thank you very much for your help. 

Paul