Forum Discussion
Using a parameter to filter my visual
- 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 stringsStep2: 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 tableits showing Everyone=81, Joe=11, Total=92
Now take the "Name" column from Seletion table and take the measure created into cardwe 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
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