Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count of Status

Hi All. I have a requirement to calculate the number of time a submission number has toggled between different teams for two scenarios.  Data below: I need to derive two columns based on the...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous See attached, Table (24). Toggle Index totals to 5, that's the overall toggle. Toggle Index Team has four 1's for Prereview and one 1 for IRB Review. Is this what you are looking for?

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler 
Thank you, I will test with the entire dataset and update.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler 

Is there any way to make this dynamic based on the slicer selections. Since we have derived the index at the power query editor, the toggle values are fixed.