DAX Formula regardless of a Category field

[JPSingh]

Hi there, I am trying to create a formula whereby I need to do the following product count + 0.65 * blank product count

e.g. for Outbound BDR it should be 14 + 0.65 * 4 = 17

In the below you have month, Product and then lead source. The problem I am having on all calculation is the product type because my calculations keep calculating Outbound BDR top (14) + 0.65 * (Blank) = 14 as it is unable to distinguish the count of non product because it is not related to a product. I need to calculate the value of lead source only regardless of product (in red) and I need to show it in this format. Any suggestions? 

[Anonymous]

Hi @JPSingh ,

May I ask if your problem has been solved. If the problem is not yet solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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

[rajendraongole1]

Hi @JPSingh create the below measure to calculate the lead source value

TotalValue =

VAR TotalCount =

    COUNTROWS('inoutbound')

VAR BlankProductCount =

    CALCULATE(

        COUNTROWS('inoutbound'),

        FILTER('inoutbound', 'inoutbound'[Product] = BLANK())

    )

RETURN

    TotalCount + 0.65 * BlankProductCount

try the above logic 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[JPSingh]

Hi @rajendraongole1 , Thank you. for the ('inoutbound') should I be using the lead_source. I have put it into a table so the field names are visible as the 'inoutbound' is what I am unsure because there could be other leadsources such as 'Inbound' that does not have a product code either.