Forum Discussion
Solved
Lookup Value and return
Hello I need help in creating a measure to valdate/lookup the information on the Invoice level. If all product types in Invoice number is "True" in Exchange then return "1" AND If all produ...
Hi gaurav-narchal ,
Because your file cannot be opened here, so I create a simple example to calculate the Invoice level ; and create a measure as follows:
level = VAR _count = CALCULATE ( DISTINCTCOUNT ( 'Table'[Exchange] ), ALLEXCEPT ( 'Table', 'Table'[ InvoiceID] ) ) RETURN IF ( _count = 2, 3, IF ( MAX ( [Exchange] ) = "FALSE", 2, 1 ) )The final output is shown below:
If it still fails to solve your problem, can you re-upload the file?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Do you want the result as a calculated column in your table or as a measure in your visual?
Ashish_Mathur - I would need this as a measure.