Add one in count

Question

Hello All.&nbsp;I have source &amp; source 1 files.Following code bring the counts of source files with extra one count.&nbsp;Like&nbsp;Source Open&nbsp; = 100&nbsp; but actual counts 99Source SCOM =&nbsp; 26&nbsp; but actual counts 25&nbsp;&nbsp; For Source 1&nbsp; , it is bringing corrcet counts&nbsp;Source 1 A = 20Source 1 P = 1&nbsp;Count = CALCULATE(COUNT(Source[Incident ID]) + COUNT('Source 1'[Parent PublicID]))&nbsp;&nbsp;&nbsp;If I add -1 as belowit fixes Source&nbsp; but reduces Source 1 by 1.&nbsp;Count = CALCULATE(COUNT(Source[Incident ID]) + COUNT('Source 1'[Parent PublicID])-1)&nbsp;I think,&nbsp; I need to add -1 with first part of code (source) , needs your help.&nbsp; Thanks&nbsp;

greg_deckler · Answer

sdhn&nbsp;Sorry, having trouble following, can you post sample data as text and expected output?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/1116882Also, 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/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

hikmer · Answer

I'd remove the calculate and use COUNTROWS function and just add the totals together.&nbsp;COUNTROWS function (DAX) - DAX | Microsoft Learn&nbsp; COUNTROWS([Source Table]) +&nbsp;COUNTROWS([Source&nbsp;1 Table])

Forum Discussion

Add one in count

2 Replies

Related content

Counting nulls

Add Count Column

Count Of Drivers

Count Measure

count distinct