Forum Discussion
Count of Status
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?
We are deriving two columns,
1. "Overall Toggle count" should be irrespective of "Pre-Review" and "IRB Review".
2. "Toggle count based on Pre-Review/IRB Review" should be for "Pre-Review" and "IRB Review" Separately.
Community ChampionAnonymous OK, so Overall Toggle count should be 4 then? Is that correct?
Greg_Deckler
Thank you, I will test with the entire dataset and update.- Greg_Deckler
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?
Overall toggle count should be 5 as we are checking the toggle irrespective of Pre-REview/IRB Review.
Whereas for Toggle count based on Pre-Review/IRB-Review, the count will be 4 when filtered for "Pre-Review"
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.