Forum Discussion

Jtbonner1986's avatar
Jtbonner1986
Helper I
1 year ago

Count Non Matching Rows With One to Many relationships

Hello,    I am trying to count the number of Non Matching rows I have in a pricing table, where the prcing table can contain multiple prices for a single material;    Example; Program Table    ...
Need Help
v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi Jtbonner1986 ,
Thanks for reaching out to Microsoft Fabric Community,
Just wanted to check in if you have resolved your query, if not please consider the following:

To count how many materials in Program A do not have any pricing records, you can use the following DAX measure:

Count of Materials Without Pricing = 
CALCULATE(
    COUNTROWS(
        FILTER(
            VALUES(Program[Material]),
            NOT Program[Material] IN VALUES(Pricing[Material])
        )
    ),
    Program[Program] = "A"
)

Here is the output:

 

 

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

 

Thank you.