Filter the projects if it exceeds the threshold , composite model

[Evanooruvan]

compare two column from different table , one is dax and other is excel , and write dax query

3 hours ago

I have two table

table 1 - direct query

table 2 - Excel

relationship created using a column called - project_name

Now i have a column named dq% in table1 and column named threshold in table 2,

now i want to write a query where if dq% greater than threshold,1 else 0,

i want the above logic to be implemented in calculated column so that i can filter the values in visualisation

many function seems to not work properly between direct and import tables.

can someone help here please

[amitchandak]

@Evanooruvan , Try to have a measure, for that you need a common dimension, unless the Table 2 is dimension

You need to have measures like

if(Average(Table1[DQ%]) > Max(Table2[Threshod]) ,1,0)

Based on level/group by  you can do segmentation

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q