Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello!
I'm new to Power BI.
I'm gong to describe my situation (I connected the software to the webapi uri 8.2 of my CRM online):
I have Entity A (with a text field "name")
I have Entity B related to A (N:1)
I have Entity C related to A (N:1)
I need to extract the number of records of A with "name" not null, that have at least one record of B AND at least one record of C.
I have no idea of the steps to fulfill my need.
Thanks in advance for the help!
Best regards
Solved! Go to Solution.
Hi @lugeno,
In table A, please create two calculated columns to get count of records B and C using the formula. Lets assume the column name used to build relationship is "field".
CountB = CALCULATE(COUNT(TableB[record),USERELATIONSHIP(TableA[field],TableB[field]))
CountC = CALCULATE(COUNT(TableC[record),USERELATIONSHIP(TableA[field],TableC[field]))
Then you can create a measure to get the the number of records of A with "name" not null, that have at least one record of B AND at least one record of C. Please review the formula below.
number=CALCULATE(COUNT(TableA[name]),FILTER(TableA,TableA[name]<>BLANK()&&TableA[CountB])>=1&&TableA[CountC])>=1))
You can create a card visual to display your result.
Best Regards,
Angelia
Hi @lugeno,
In table A, please create two calculated columns to get count of records B and C using the formula. Lets assume the column name used to build relationship is "field".
CountB = CALCULATE(COUNT(TableB[record),USERELATIONSHIP(TableA[field],TableB[field]))
CountC = CALCULATE(COUNT(TableC[record),USERELATIONSHIP(TableA[field],TableC[field]))
Then you can create a measure to get the the number of records of A with "name" not null, that have at least one record of B AND at least one record of C. Please review the formula below.
number=CALCULATE(COUNT(TableA[name]),FILTER(TableA,TableA[name]<>BLANK()&&TableA[CountB])>=1&&TableA[CountC])>=1))
You can create a card visual to display your result.
Best Regards,
Angelia
User | Count |
---|---|
134 | |
72 | |
72 | |
55 | |
52 |
User | Count |
---|---|
202 | |
95 | |
63 | |
62 | |
53 |