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?
Thank you for the detailed help. I will try the same on the actual dataset and update.
Also can you please let me know if Index has to be added? If yes, could you please help provide the code with the Index field.
Thank you
Poojitha
Community ChampionAnonymous Sure, updated PBIX attached same table.
Toggled Index =
VAR __PreviousIndex =
MAXX (
FILTER (
'Table (24)',
[Index] < EARLIER ( [Index] )
&& [Submission Number] = EARLIER ( [Submission Number] )
&& [IRB Staff/Study Team] <> "FALSE"
),
[Index]
)
VAR __PreviousTeam =
MAXX (
FILTER (
'Table (24)',
[Index] = __PreviousIndex
&& [Submission Number] = EARLIER ( [Submission Number] )
),
[IRB Staff/Study Team]
)
RETURN
IF (
[IRB Staff/Study Team] = "FALSE"
|| ISBLANK ( __PreviousTeam )
|| __PreviousTeam = [IRB Staff/Study Team],
0,
1
)I tried to use the logic from the pbix file you shared, but the field is not matching with the values as expected.
Please note , we need to derive two columns in PBI which is "Overall Toggle Count" and "Toggle Count based on Pre-Review and IRB Review".
These two columns which are available in the file is for refrence.
Thanks
Poojitha
Can someone please help on fixing this
- Greg_Deckler
Anonymous I need to understand your expected results.
You state:
Eg : For the first submission number, for Pre-Review type : count is 4
Cell U3, U4 (U 3 and U4 - same team ) to U5 = 1 time (IRB Staff to Study Team)
U5 to U 6 = 1 time ( Study team to IRB Staff)
U6 to U7 = 1 time (IRB Staff to Study Team)
U7 to U8 = 1 time ( Study team to IRB Staff)
Total 4 times
4 is the number that Toggled returns as you show and is highlighted. So, first, is Toggled flagging the right rows or not?