Forum Discussion
Dax Filter 2 tables
Hi, I have 2 related table many to one Table 1 Name category A Category 1 B Category 1 C Category 2 D Category 2 E Category 2 F Category 3 G Category 4 H...
conform: COUNTROWS ( FILTER ( a, [has WP] = 0 ) )
non-conform: COUNTROWS ( FILTER ( a, [has WP] > 0 ) )
lbendlin
Super User
Super UserMEASURE =
VAR a =
ADDCOLUMNS (
SUMMARIZE ( Table1, [Name] ),
"has WP", CALCULATE ( COUNTROWS ( Table2 ), Table2[Policy] = "WP" )
)
RETURN
ROUNDDOWN (
DIVIDE ( COUNTROWS ( FILTER ( a, [has WP] = 0 ) ), COUNTROWS ( a ), 0 ),
2
)
lbendlin Hi, Many thanks for your quick reply. The measure works, I would like to sort out the list of Conform and No Conform, could you please advise the measure to count the number of Conform and Non Conform.
If the same Name has FIXED and WP, this Name is not conformed.
Only the Name without any WP is Conform
Thank you again.
Regards,
Tg