Creating a Customized Measure

[utsavlexmark]

Hello All,

I have a table as follows:

Campaign-ID	Month	Year	URL	Unique Visitors(Total)	Unique Visitors(Campaign Traffic)
abcd	Jan	2024	a.com	1000	400
efgh	Jan	2024	a.com	1000	300
ijkl	Jan	2024	a.com	1000	200
mnop	Feb	2024	a.com	700	350
qrst	Feb	2024	a.com	700	250
uvwx	Feb	2024	a.com	700	150

Now the requirement is 
1. Total for column "Unique Visitors(Total)" will show 1700 (a.com for Jan 1000+a.com for Feb 700) - but it is showing 5100.

2.  Need to create a measure for contribution Campaign Traffic in total traffic.

Please suggest some technique.

Regards

Utsav

[Anonymous]

Hi, @utsavlexmark 

Regarding the second question, what is your desired output?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shafiz_p]

Hi @utsavlexmark  Try this for Unique Visitors(Total):

Unique Visitors(Total)=

SUMX(

    SUMMARIZE(

        'Table',

        'Table'[Month],

        "DistinctValue", MAX('Table'[Unique Visitors(Total)])

    ),

    [DistinctValue]

)

Hope this helps!!
If this solved your problem, Please accept it as a solution!!

Best Regards,
Shahariar Hafiz