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 ,


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.