Forum Discussion

crodrigueza's avatar
crodrigueza
Regular Visitor
4 years ago
Solved

filter a table excluding selected elements

Hi,    I would like to make a count on a table, but excluding first some elements in another table. The next example may clarify the situation:   Table A:   User Product A Product A ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, crodrigueza 

     

    Since you have created a one-to-one relationship in two tables.

    You can directly create the measure like this:

    Measure = var a= COUNTROWS(TableB)
var b=COUNTROWS(ALL(TableB))
return b-a

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, crodrigueza 

 

Since you have created a one-to-one relationship in two tables.

You can directly create the measure like this:

Measure = var a= COUNTROWS(TableB)
var b=COUNTROWS(ALL(TableB))
return b-a

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey