Skip to main content

how to use measure name or values in multiple sheets. we can do using parameter but it is limited since we can select only one at a time.

 

In below example data, I have created measure value  Graduate Users for Graduate sing

 

IIF([Graduate]="Y",1,0)   this will give no.of users for graduate but I can not use this field across other sheets for data drill down since it is a measure value, please help me if there is any other alternate to get no.of users per Graduate & Non Graduate and I can use this across multiple sheets using action filters.

 

User

 

Graduate

 

Non graduatexyzYesNoAbcNoYesMNOYesNoIJKNoYes
6 answers
  1. Sep 17, 2019, 10:02 PM

    Oh, ok.  Well, I think that's pretty easy: in your "Add Filter Action" window, for "Source Sheets" select your first sheet (the one with the pie chart on it), and for "Target Sheets" select your second sheet.  Then be sure to use the "Select" button, and it should be ready to go:

     

    Oh, ok.

     

    Please let us know if that solved your issue.

    Kaz.

0/9000