Forum Discussion
Helper IVTable Matrix Conundrum, Looking for ideas!
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)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.
Community Championdbrandone You will want to add ISINSCOPE to your selector measure so that you always return 1 when at the Month Name level. Otherewise, seems like you are familiar with what I call a Complex Selector: The Complex Selector - Microsoft Power BI Community
Helper IVAppreciate the response Greg_Deckler. I haven't messed with ISINSCOPE yet and just read the DAX guide on it and trying to visualize how to implement it. Below is the measure for Transplant Recoveries, and if I am understanding what you are saying, I need to tie ISINSCOPE with MonthName inside of the below measure, correct?
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 Result- Greg_Deckler
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)- dbrandone
Greg_Deckler July still dropped off after the ISINSCOPE add to the measure.
- Greg_Deckler
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.