topic Re: Combine two codes in DAX Commands and Tips

Combine two codes

sdhn — Thu, 23 Feb 2023 19:23:31 GMT

Hello All,

I have two codes in report and working fine..

Count = COUNT(Source[Incident ID])+0

Count2 = COUNT('Source 1'[Parent PublicID])+0

I got resulst in two visuals.

Now I want to dispaly in one visual.

How can I combine both codes? I will appreciate your help. Thanks

Cheers

TaylorPBI21 — Thu, 23 Feb 2023 19:48:30 GMT

Hi sdhn ,

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

Many Thanks,

Taylor

sdhn — Thu, 23 Feb 2023 20:04:10 GMT

yes, on one visual

FreemanZ — Thu, 23 Feb 2023 22:59:20 GMT

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 — Thu, 23 Feb 2023 23:15:29 GMT

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

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