Forum Discussion

dbrandone's avatar
dbrandone
Icon for Helper IV rankHelper IV
5 years ago
Solved

Table 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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 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)
  • Greg_Deckler's avatar
    Greg_Deckler
    5 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's avatar
dbrandone
Icon for Helper IV rankHelper IV
5 years ago

Appreciate 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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 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)
  • dbrandone's avatar
    dbrandone
    Icon for Helper IV rankHelper IV
    5 years ago

    Greg_Deckler July still dropped off after the ISINSCOPE add to the measure.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      5 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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