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.
Greg_Deckler
Community Champion
4 years agodbrandone Did you add that measure to the matrix? If not, try that and turn off word wrap and then shrink the column to nothing.