Dax query to create a measure that returns values from another columns based on slicer selection

Anindita198 — Mon, 14 Nov 2022 06:16:03 GMT

I want to create a measure which will return sum of unique visits and unique visitors based on pagename selected in slicer .

Note - pagename, visits and visitors column are all part of same table .

Re: Dax query to create a measure that returns values from another columns based on slicer selection

Anonymous — Tue, 15 Nov 2022 01:53:13 GMT

Hi Anindita198

According to your needs , I create a sample to return the value you want .

Original data :

Then add a slicer with pagename .

Then create a measure to count sum of unique visits and unique visitors .

Measure = VAR _VISITORS=DISTINCTCOUNT('Table'[visitors]) VAR _VISITS=DISTINCTCOUNT('Table'[visits]) RETURN _VISITS+_VISITORS

When you choose pagename =page 1,you will get a result like this (unique visitors is 4 and unique visits is 4 , so the sum is 8):

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Dax query to create a measure that returns values from another columns based on slicer selection in DAX Commands and Tips

Dax query to create a measure that returns values from another columns based on slicer selection

Re: Dax query to create a measure that returns values from another columns based on slicer selection