Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sdhn
Responsive Resident
Responsive Resident

Combine two codes

Hello All,

 

I have two codes in report and working fine..

 

1) 

Count = COUNT(Source[Incident ID])+0
 
2) 
Count2 = COUNT('Source 1'[Parent PublicID])+0
 
I got resulst in two visuals.
 
sdhn_0-1677180197344.png

 

Now I want to dispaly in one visual.
 
How can I combine both codes?  I will appreciate your help.  Thanks
 
 Cheers 
4 REPLIES 4
FreemanZ
Super User
Super User

hi @sdhn 

you may just try like:

Count = 
COUNT(Source[Incident ID])+
 COUNT('Source 1'[Parent PublicID])+0
 
in case of issue, please show
1) how are the two tables related
2) what context do you have for the expected measure, or how would you like to present the measure?
sdhn
Responsive Resident
Responsive Resident

sdhn_0-1677193987101.png

All files exceed by total count of 1.  They all files belongs to same folder called Source.

without + 0 is same results.

 

If I do -1 

 

sdhn_1-1677194093691.png

 

Two files reduce by count 1.  Both belongs to SOURCE 1 folder.

 

TaylorPBI21
Resolver I
Resolver I

Hi @sdhn ,

 

Are you looking a solution to display the total count for both combined in a card visual? 😎

Many Thanks,

 

Taylor

sdhn
Responsive Resident
Responsive Resident

yes,  on one visual 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.