Forum Discussion
dbrandone
Helper IV
4 years agoTable Matrix Conundrum, Looking for ideas!
Hi Everyone, I have a matrix that I am putting together and the second value in the row field(drill down) is pulling all values relating to the columns instead of the values that are not zero. Th...
- 4 years ago
dbrandone Try:
Transplant Intent Recoveries Total = VAR TIRtotal = CALCULATE( COUNTROWS(v_EyeRecovery_EyeTissueRecovered), v_EyeRecovery_EyeTissueRecovered[RecoveryIntent] = "Transplant", v_EyeRecovery_EyeTissueRecovered[ParentId] = BLANK() ) VAR Result = IF( ISBLANK(TIRtotal), 0, TIRtotal ) Return IF(ISINSCOPE('Dates'[MonthName]),1,Result) - 4 years ago
dbrandone Did you add that measure to the matrix? If not, try that and turn off word wrap and then shrink the column to nothing.
dbrandone
Helper IV
4 years agoGreg_Deckler July still dropped off after the ISINSCOPE add to the measure.
Anonymous
4 years agoNot applicable
Hi dbrandone,
Any update for these? Did Greg_Deckler 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng