locked
How to filter related table RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello. I'm using this formula to get a count for each invidual value in my lookup table. Is there a way that I can filter the count so that it returns, only values, based on values in ANOTHER column in the non-lookup table? Or can I use measure instead of the invoice num column? Thanks. 

    =COUNTX(RELATEDTABLE('Big Invoices My Baby'),'Big Invoices My Baby'[IV Falcon Invoice Num])

    Wednesday, September 7, 2016 6:22 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Albo44,

    >>Is there a way that I can filter the count so that it returns, only values, based on values in ANOTHER column in the non-lookup table?

    I am trying to reproduce your issue in my local environment using following three linked tables. 


    I calculate the count of [ID] in linked Table2 and get the expected results. Then get the count based on the values is “Yes” in another column  [Values] of Table3 as follows.

    >> Or can I use measure instead of the invoice num column? 
    No, you don’t use measure. Because COUNTX function counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table. While, measure is used to aggregate values from many rows in a table. They are incompatible.


    Regards,
    Angelia

    Thursday, September 8, 2016 10:14 AM