Forum Discussion

Jtbonner1986's avatar
Jtbonner1986
Helper I
1 year ago
Solved

Count Non Matching Rows

Hi,    Sorry for the basic question here: I have 2 tables, a pricing table and a material table (joined by material ID). I want to understand where i have a record in my material table but do not ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Jtbonner1986 

     

    Create a one-to-many single direciton relationship from Price to Material

    Create this measure:

    count = 
CALCULATE (
    COUNTROWS ( Material ),
    KEEPFILTERS ( ISBLANK ( 'Price'[Material] ) )
)

     

Azadsingh's avatar
Azadsingh
Resolver II
1 year ago

Please share more information, I am not clear what you are expecting in result.

  • Jtbonner1986's avatar
    Jtbonner1986
    Helper I
    1 year ago

    i want a single card visual displaying the number of materials which do not have a price. in this case material 345 and 678 do not have prices so i would want the result 2