Query Help with Blank Value

[tpowell86]

hi, can someone please help with what im doing wrong with this query,  

for the column do_reqqty new, if cf_factor is empty i need to divide by 100 other wise i need to divide by the value in cf_factor. 

the results i should be getting are 8 in row 1 and 1 in row 2, however it is dividing everything by 100.  

thanks in advance, 

[Anonymous · Accepted solution]

@tpowell86 

This could because you do not have a direct relationship between the doline table and product profile table. Try create a inactive relationship between the 2 tables then use userelationship() to call out the relationship in the dax. 

DAX USERELATIONSHIP Function - Power BI Docs\

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @tpowell86 ,

I guess that's a measure right?

In that case you can't use RELATED like that. The RELATED function returns the value from a related table on the 1 side. For that reason RELATED needs a row context. So you can only use it in a calculated column or in a function that provides a row context like an iterative function like SUMX.

If you give more context on what you want to do (tables, data model, relationships, desired result) or in best case if you can also share the file, I can help you to find a solution.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[tpowell86]

hi, sorry for the lack of detail,  it is a calculated column.

doreqqty is from the doline table, cf_factor is from the product profile table. for a few records in doline there is no match in cname as they are free text entries so then return a blank from cf_factor.