Calculate + Countrows does not deliver correct result

[ChrisCollao]

Good morning, community!

I come to you because I've been hitting the table for a few days of how to get a calculation, but it's not working.

I'll explain a little bit.

I have a table with events, and those events are assigned to a code.

I made a table with the Distinct function to have the codes sorted, and I want to count the times that each code appears in the event tables, but it's not counting everything.

In the following image I show the equation I did to count:

I want to count how many times each of the codes in the [SMCS_Subgr_Cod] column appears in the [SMCS_Subgroup] column of the [dw][FluidAnalysis] table.

The strange thing is that for example the code 1000 is counted correctly, but the 1250 and 1350 (which do appear in the indicated table) do not record values:

Am I making any mistakes in the formula? Is there a better way to do it?

Thank you very much in advance for the help.

[v-shex-msft]

HI @ChrisCollao,

I'd like to suggest you take a look at following blog who told about the ALL functions in DAX expression, it will help you to clarify how these functions work:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT  

Regards,

Xiaoxin Sheng

[Greg_Deckler]

@ChrisCollao - Hard to say. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.