Forum Discussion

dzabba00's avatar
dzabba00
New Member
7 years ago

Create non-numeric measure from dimension attribute

  Hello Dax Masters! I have two tables in my model, first is standard fact table and the second one is dimension (relation: many from fact - one dimension) relation key:[key: shop_id,prod_id,yyyymm...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

Hi dzabba00,

 

According to your description and image, I am not clear about your logic, could you please  explain this in details?

1.Products that are allowed for sell: CaniSellit = YES and SalesAmount
2.Procuts that are not allowed for sell: CanIsellit= No but got salesamount

3.Product that are not allowed for sell: CanIsellit = No and dont  have salesamount 

Did you mean when CaniSellit = “yes”, show saleamount in  Matrix, when CaniSellit = “No” but have saleamount, show 0, when CaniSellit = “No” and no saleamount , show blank in Matrix?

By the way, Why the corresponding “Sales Amount” for “2019-03” is displayed as 300, while the actual value in “Sales” table is 100? Do you want running total? And there is no 2019-05 and 2019-06 in sample  table, how to get the displayed sales amount for them in Matrix?

Best Regards,
Zoe Zhi

 

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