To add slicer in calculated table.

[Anonymous]

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. 

[VahidDM]

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✌️!!

[Anonymous]

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.

[VahidDM]

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🙏!!

[Anonymous]

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. 

 

[VahidDM]

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🙏!!

[Anonymous]

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

[VahidDM]

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🙏!!

[Anonymous]

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

 

[VahidDM]

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!!

[Anonymous]

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

[VahidDM]

Hi @Anonymous 

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

Appreciate your Kudos!!

[Anonymous]

Hi @VahidDM please help to sort it out. 

[Anonymous]

https://gofile.io/d/s1lPqZ

• Please check this also. 

[Anonymous]

Hi @VahidDM 

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