topic Re: To add slicer in calculated table. in DAX Commands and Tips

To add slicer in calculated table.

Anonymous — Mon, 20 Sep 2021 10:32:36 GMT

Actually I have a three table one is fact table and other two dimensional table. ie, calulated table.

Eg: table 1 table 2 table 3

Table 1 is main table. Table 2 and 3 is calculated table. I need to add slicer from table 1 to table 3.but there is no relationship among those tables.

How to add slicer to the calculated table?

Anyone please help to sort it out.

Re: To add slicer in calculated table.

VahidDM — Mon, 20 Sep 2021 11:46:35 GMT

Hi Anonymous

What do you want to do? Do you want to use a slicer to filter Table 1 and Table 3 without a relationship?

https://www.sqlbi.com/blog/marco/2010/02/09/how-to-relate-tables-in-dax-without-using-relationships/

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

Appreciate your Kudos✌️!!

Re: To add slicer in calculated table.

Anonymous — Mon, 20 Sep 2021 12:58:37 GMT

Actually table 3 is calculated table. There is no unique values in both the tables.so we need to use that slicer in calculated table ie, table 3 as a filter.

Re: To add slicer in calculated table.

VahidDM — Tue, 21 Sep 2021 03:32:10 GMT

Hi Anonymous

You can use SELECTEDVALUE in the Calculated table dax codes to filter that based on the selected item on slicer.

Can you share a sample of your file here after removing sensitive ata?

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

Appreciate your Kudos🙏!!

Re: To add slicer in calculated table.

Anonymous — Tue, 21 Sep 2021 11:26:58 GMT

Hi VahidDM.Thanks for ur help

I have attached the image of that calculated table.in that i have taken a measure from 360 main table. From that main table I need to get the slicer and add it to the calculated table dax.for example.in the slicer there are four names like

Sujith

Vahid

Chan

Kong.

If I filtered these names it should show datas for selected name.

Re: To add slicer in calculated table.

VahidDM — Tue, 21 Sep 2021 12:57:15 GMT

Hi Anonymous

Try to use a filter in your codes, something like this:

Summary Data 1 = calculatetable((UNION(.......Your Codes),filter(360,360[Name Column]=SELECTEDVALUE(360[Name Column])))

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

Appreciate your Kudos🙏!!

Re: To add slicer in calculated table.

Anonymous — Tue, 21 Sep 2021 16:11:36 GMT

Hi, it showing as an error. I have send the screenshot of that.

Re: To add slicer in calculated table.

VahidDM — Tue, 21 Sep 2021 22:37:14 GMT

Hi Anonymous

Befor filter in your code close Union parentheses.

it should be )),filter(

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

Appreciate your Kudos🙏!!

Re: To add slicer in calculated table.

Anonymous — Wed, 22 Sep 2021 06:14:27 GMT

Hi@VahidDM.if I used that no error is showing but there is no values are showing as I attached in the screenshot.

Re: To add slicer in calculated table.

VahidDM — Wed, 22 Sep 2021 11:51:26 GMT

Hi Anonymous

Can you share your file or sample of your data here? to find out what are those measures and how to find a good solution.

Appreciate your Kudos!!

Re: To add slicer in calculated table.

Anonymous — Thu, 23 Sep 2021 11:41:23 GMT

Hi VahidDM i have attaches the sample file. http://app.powerbi.com/groups/me/reports/702250ad-915f-42bb-8665-f1f737d69e05/ReportSectionca12deafa5ab2c79a1a3 . Please check and help to sort out.

Re: To add slicer in calculated table.

VahidDM — Thu, 23 Sep 2021 21:31:30 GMT

Hi Anonymous

Please share your PBIX file (Desktop version); you can share that on google drive, Dri=opbox, Gofile.io,...

Appreciate your Kudos!!

Re: To add slicer in calculated table.

Anonymous — Fri, 24 Sep 2021 12:22:58 GMT

Hi VahidDM

https://www.dropbox.com/s/iusabz24q6qytdp/sujith.pbix?dl=0 is that fine?

Re: To add slicer in calculated table.

Anonymous — Fri, 24 Sep 2021 12:27:58 GMT

https://gofile.io/d/s1lPqZ

Please check this also.

Re: To add slicer in calculated table.

Anonymous — Tue, 28 Sep 2021 06:30:15 GMT

Hi VahidDM please help to sort it out.