Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago
Solved

How to make Pro Class Description appear at Inventory Table ?

Hi All I have a inventory Table , the Raw data file lack of Pro Class Description it only have Pro Class Code , So the report not easy understand.  My Sales Table have Pro Class Code and Descriptio...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi admin11 

     

    Since you already have an inactive relationship between Inventory Table and SALES table on pro_class_code columns, you can create below measure to get the pro_class_desc and put it in the table.

    Measure 6 = CALCULATE(SELECTEDVALUE(SALES[PRO_CLASS_DESC]),USERELATIONSHIP(SALES[pro_class_code],INVC[PRO_CLASS_CODE]),CROSSFILTER(SALES[pro_class_code],INVC[PRO_CLASS_CODE],OneWay_RightFiltersLeft))

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

daxer-almighty's avatar
daxer-almighty
Solution Sage
5 years ago

Again, use Power Query.