Forum Discussion

ditoparker's avatar
ditoparker
New Member
1 year ago
Solved

Using a parameter to filter my visual

Hello! for context, I am veteran Tableau user on his first week using Power BI so apologies in advance if I am approaching this the wrong way. I have one column with the values: Joe Joe Everyon...
Need Help
  • ullassl1991's avatar
    ullassl1991
    1 year ago

    Hi ditoparker , I have taken some sample of data based on your explination like this table Sheet1

     

    I just worked on this data I have a solution on your requirement
    Step1: Create a unrelated table "Selection" with this strings

    Step2: Create the follwing measure to assign values to those selections

    Measure = SWITCH(
    SELECTEDVALUE(Selection[Name]),
    "Joe",SUM(Sheet1[work]),
    "Everyone",CALCULATE(SUM(Sheet1[work]),Sheet1[name]="Everyone"))

    Step 3 
    This is the actual value of work as per the table

    its showing Everyone=81, Joe=11, Total=92
    Now take the "Name" column from Seletion table and take the measure created into card

     

    we can see overall value is shown under Joe and remaining value shown under everyone
    I hope it gives the solution you want , let me know
    Thank you



v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi ditoparker ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi ditoparker ,


    I wanted to check if you had the opportunity to review the information provided by ullassl1991 . Thank you ullassl1991 for providing possible solution. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

    Thank you.

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      Hi ditoparker ,

      I wanted to check if you had the opportunity to review the information provided by ullassl1991 . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution so other members can easily find it.

      Thank you.