Count Ref IF

[HenryJS]

Hi all,

How do I create a measure which counts 'CompanyHQOriginalSourceRef' IF Type = "Business Development" or "Top 10"?

[Mariusz · Accepted solution]

Hi @HenryJS 

Try This 

Measure = 
CALCULATE(
    DISTINCTCOUNT( 'Table'[CompanyHQOriginalSourceRef] ),-- or COUNTROWS( 'Table' ),
    'Table'[Type] IN { "Business Development", "Top 10" }
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[v-shex-msft · Accepted solution]

Hi @HenryJS,

I haven't found any ranking fields in your table, can you please explain more about your data structure?

How to Get Your Question Answered Quickly 

In addition, You can try to use the following measure formula if it suitable for your requirement:

Measure =
CALCULATE (
    COUNTA ( Table[CompanyHQOriginalSourceRef] ),
    FILTER (
        ALLSELECTED ( Table ),
        [Type] = "Business Development"
            && [Rank] <= 10
    )
)

Regards,

Xiaoxin Sheng

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=CALCULATE(COUNTROWS(Data),Data[Type]="Business Development"||Data[Type]="Top 10")

Hope this helps.

[v-shex-msft · Accepted solution]

Hi @HenryJS,

I haven't found any ranking fields in your table, can you please explain more about your data structure?

How to Get Your Question Answered Quickly 

In addition, You can try to use the following measure formula if it suitable for your requirement:

Measure =
CALCULATE (
    COUNTA ( Table[CompanyHQOriginalSourceRef] ),
    FILTER (
        ALLSELECTED ( Table ),
        [Type] = "Business Development"
            && [Rank] <= 10
    )
)

Regards,

Xiaoxin Sheng

[Mariusz · Accepted solution]

Hi @HenryJS 

Try This 

Measure = 
CALCULATE(
    DISTINCTCOUNT( 'Table'[CompanyHQOriginalSourceRef] ),-- or COUNTROWS( 'Table' ),
    'Table'[Type] IN { "Business Development", "Top 10" }
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn