Forum Discussion

MarkSL's avatar
MarkSL
Icon for Helper V rankHelper V
8 years ago
Solved

Matrix show missing values as zero - pbix attached

Hi,   It seems that this is a common question, but even from reading the many posts I am still stuck so I would really appreciate some assistance!   My model has: 2 dim tabes: Date, Products. 2...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey MarkSL,

     

    I added a stockqty measure and a hasdata measure and filtered based on hasdata.

     

    StockQtyMeasure = IF(ISBLANK(SUMX(Purchases, Purchases[StockQty])), 0,SUMX(Purchases, Purchases[StockQty]))

    HasData = IF(AND(Sales[SalesQtyMeasure]=0,[StockQtyMeasure]=0),"No","Yes")

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey MarkSL,

 

I added a stockqty measure and a hasdata measure and filtered based on hasdata.

 

StockQtyMeasure = IF(ISBLANK(SUMX(Purchases, Purchases[StockQty])), 0,SUMX(Purchases, Purchases[StockQty]))

HasData = IF(AND(Sales[SalesQtyMeasure]=0,[StockQtyMeasure]=0),"No","Yes")

 

  • MarkSL's avatar
    MarkSL
    Icon for Helper V rankHelper V
    8 years ago

    Hi Anonymous

     

    That did the trick!  Many thanks, really appreciate it :)

     

    Cheers

     

    Mark