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.

v-jingzhang's avatar
v-jingzhang
Community Support
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.

admin11's avatar
admin11
Memorable Member
5 years ago

v-jingzhang 

I have try to test your code with my PBI data , i notice one of the 

Hope you can share with me where go wrong ?

 

Paul