Forum Discussion

SteveBrou's avatar
SteveBrou
Frequent Visitor
6 years ago

CALCULATETABLE slicing alternative

I currently have a table that contains information regarding job positions that are requisitioned. These tables lists are housed in SP as custom lists and follow a flow through recruiting to HR. I ha...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

SteveBrou , You can not create a dynamic table using slicer.

You can use Table as a variable in a measure and that can be dynamic

measure

var _t1 = calculatetable(t1,filter(t1[project]=selectedvalue(table[project]))

Return

countx(_t1,[Col1])

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

SteveBrou's avatar
SteveBrou
Frequent Visitor
6 years ago

amitchandak, One of the tables is listed below (it's the same concept for the 3 different scenarios so if I understand one, I should be able to apply to the other 2):
Recruiting Table

Job IDJob TitleProjectTarget Start DateRecruiting StatusCreation Date
123Testing EngineerProject 17/5/202026/1/2020
124AnalystProject 27/15/202006/15/2020
125DeveloperProject 27/10/202026/13/2020

 

I have 3 cards containing the measures to calculate the following: 1. Open Positions, 2. Positions in Progress, and 3. Positions filled. The calculated table that I have for open positions is simple - Recruiting Status =2. This is the filter that tells me the positions in the table that are open. When the user clicks on the card, they go to the table containing information about all the current open positions. My current set up works but I can't use the slicers to look at individual projects or group of projects.

I had to re-read your instructions on the dynamic measure a couple times but I think I may be seeing a little bit of the light on that one. Essentially you are setting up a variable that uses the the calculation for the calculated table instead of the name of the calculated table. How do I display the results in a table. I'm seeing daylight but the sun hasn't risen quite yet 🙂

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi SteveBrou ,

     

    The following is our understanding,

    You have three measures that calculate the count of position status, and put them to three card.

    When you click one card, for example, you click open positions card, it will jump to a list table that only contains open positions information.

    If our understanding is correct, sorry for that there is no perfect solution.

    But you can refer this solution as following. Use the button to jump to page, and make a fixed page in advance.

     

    1. Create three pages that contains the Open Positions, the Positions in Progress and Positions filled. We just can use the page filter.

     

     

     

    2. Then we can add three buttons below the three cards, to jump to different page.

     

     

     

    3. And add a back button in each page.

     

     

    4. At last, when you want to see the detail of open positions, you can select the button bellow the open positions.

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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