Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Need help. I am stuck.
Can I create a new measure using 2 other measures. If not what is the correct method to get net members.
I have created two measures
MembersCountInvoicetable = DISTINCTCOUNT(SalesInvoicesandcreditnotesappend[Contact])
MembersresignationCountcredittable = DISTINCTCOUNT(CreditNotes[Contact])
I have used the two measure A -B = C or 500 - 30 = 470 to get net members as per below
NoOfMembers = SalesInvoicesandcreditnotesappend[MembersCountInvoicetable]-SalesInvoicesandcreditnotesappend[MembersresignationCountcredittable]
Result should be 470 but is not.
Cheers
Elizabeth
Hi @ElizabethTachji,
We could create a new measure using 2 other measures via subtract method. But the result returned by a measure will be affected by row context. Especially, the two basis measures are calculated from two tables.
For more advice, please share your sample data and show us desired output.
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |