Forum Discussion

cj_oat's avatar
cj_oat
Icon for Helper I rankHelper I
1 year ago
Solved

The Value does not show when expand Metrix Table

Hi all,   I have an issue regarding Matrix Table, so below is the screenshot where I expanded Matrix table but you may see that in the column "Month Cover" the number does not show in the sub-rows ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, cj_oat 

    When you delete either Consumer or Product, the Month Cover Measure has a value, which means:
    When the external context satisfies both the Consumer and the Product, there is no corresponding data. So the result of the computation is empty, which is a very common external context problem.

    To do this, apply a calculate function to your original metric and remove one of the row label filters via removefilters or all.

    Month Cover = 
VAR CurrentWeek = SELECTEDVALUE('Data Report'[Latest Week], MAX('Data Report'[Latest Week]))
VAR SalesCalc = 
    SWITCH(TRUE(),
        FORMAT(SELECTEDVALUE('Data Report'[Today]), "DDD") = "Mon",
        CALCULATE(SUM('Data Report'[Sales Unit]), 'Data Report'[Week Number] >= CurrentWeek - 3),
        CALCULATE(SUM('Data Report'[Sales Unit]), 'Data Report'[Week Number] >= CurrentWeek - 3 && 'Data Report'[Week Number] < CurrentWeek)
    )
RETURN
CALCULATE(DIVIDE([Inventory], SalesCalc, BLANK()),REMOVEFILTERS('Data Report'[Consumer]))

    OR

    Month Cover = 
VAR CurrentWeek = SELECTEDVALUE('Data Report'[Latest Week], MAX('Data Report'[Latest Week]))
VAR SalesCalc = 
    SWITCH(TRUE(),
        FORMAT(SELECTEDVALUE('Data Report'[Today]), "DDD") = "Mon",
        CALCULATE(SUM('Data Report'[Sales Unit]), 'Data Report'[Week Number] >= CurrentWeek - 3),
        CALCULATE(SUM('Data Report'[Sales Unit]), 'Data Report'[Week Number] >= CurrentWeek - 3 && 'Data Report'[Week Number] < CurrentWeek)
    )
RETURN
CALCULATE(DIVIDE([Inventory], SalesCalc, BLANK()),ALL('Data Report'[Consumer]))

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

cj_oat's avatar
cj_oat
Icon for Helper I rankHelper I
1 year ago

Hi DataNinja777 ,

 

I have tried changing DAX but it still does not work (still showing BLANK), however, if I removed sub-row to have just only one row (either "Consumer" row or "Product" row) then the Month Cover will show correctly. Dont know why when I put sub-row then the Month Cover number disappeared.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, cj_oat 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

 

 

Best Regards

Jianpeng Li