Forum Discussion

jmeyer348's avatar
jmeyer348
Frequent Visitor
1 year ago
Solved

matrix visual column range

Hi everyone!         I'm having a bit of an issue with a matrix visual that I'm trying to create.  I've reproduced a simpliefied version of the issue in the image below.  Basically, I want the year-...
  • jmeyer348's avatar
    jmeyer348
    1 year ago

    Kedar_Pande , Solved! I used your method, except I made one change.  I updated the "Usage" measure to return 0 if it did not find any rows to do the calculation.  Here is the DAX code:  

    Usage =
    VAR Last12Months =
    CALCULATE(
        SUM(Sheet1[Total Usage]),
        FILTER(
            DateTable,
            DateTable[Date] >= EDATE(TODAY(), -12) && DateTable[Date] < TODAY()
        )
    )
    RETURN
    IF(ISBLANK(Last12Months), 0, Last12Months)
     
    Once I made this change, I was able to see rows that did not have any usage in the last 12 months.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

I think there is a setting to show items with blanks.  Try to turn that on.  Not even sure whether that setting applies to a matrix table or not - please check.

  • jmeyer348's avatar
    jmeyer348
    Frequent Visitor
    1 year ago

    Anish_Mathur, Can you tell me where  can find this option?  I do see a "blank rows" toggle under the visualization pane, but all this appears to do is insert a blank row in between each populated row.  It doesn't keep material numbers that have no usage in the last 12 months.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      You already have a solution.