Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measures and Calculated Columns that Look at Multiple Unique Identifiers

Hi Community!   I have three tables of data: 1) Enquiries - has fields of Enquiry ID, Case ID, In Scope, Priority 2) Cases - has fields of Case ID, Case Type, Status (Cases are enquiries that hav...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-yueyunzh-msft 

Thank you for your reply. 

 

Your DAX does stop the error ppering but, when I filter by the new colum (Mandatory Case) everything is showing as 'non-mandatory and I know that is not true.
I need the DAX to basically say if 

1. in scope is 'Yes'

and

2. Priority is 'High

and

3. Case type is 'In-house'

and

4. ANY of the vechile types related to the case is 'Hatchback' then the result is "mandatory" otherwise "discretionary"

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

Thanks for your quick response!

I check it in my test data , i think the logic has no problem,you can see each parameter return per row:

In your IF() logic , it actualy return the "Discretionary".

 

 

 

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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