Forum Discussion
Calculate + Countrows does not deliver correct result
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.
2 Replies
- Greg_Deckler
Community Champion
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. 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
