Forum Discussion

itsranga's avatar
itsranga
Helper I
1 year ago
Solved

DAX filter condition not working

Hi, i have 2 table in Power bi    Actual Data     if i click table 1 any row created date based i need to filter second table schedule start date  example (if click first table first...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi itsranga 

     

    Please try this:

    No of ID =
COUNTROWS ( FILTER ( 'Table2', 'Table1'[Measure] = 1 ) )

    The result is as follow:

    Best Regards

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi itsranga 

 

Please try this:

No of ID =
COUNTROWS ( FILTER ( 'Table2', 'Table1'[Measure] = 1 ) )

The result is as follow:

Best Regards

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