Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a dataset where the products are listed in various websites as per the below table.
How can I calculate the distinct count of products based on the websites that they are listed against?
Desired solution like this:
1. Products in all 3 website = Distinct count of Product when website = "Own+Amazon+Other"?
1. Products in any 2 website = Distinct count of Product when website = "any two website"?
Thanks in advance!
Solved! Go to Solution.
You can first create a new table by summarizing the original table with below code.
Table 2 = SUMMARIZE('Table','Table'[Product],"websites count",DISTINCTCOUNT('Table'[Websites]))
Then create below measures to count from the new table.
Products in all 3 website = CALCULATE(DISTINCTCOUNT('Table 2'[Product]),'Table 2'[websites count]=3)
Products in any 2 website = CALCULATE(DISTINCTCOUNT('Table 2'[Product]),'Table 2'[websites count]=2)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
You can first create a new table by summarizing the original table with below code.
Table 2 = SUMMARIZE('Table','Table'[Product],"websites count",DISTINCTCOUNT('Table'[Websites]))
Then create below measures to count from the new table.
Products in all 3 website = CALCULATE(DISTINCTCOUNT('Table 2'[Product]),'Table 2'[websites count]=3)
Products in any 2 website = CALCULATE(DISTINCTCOUNT('Table 2'[Product]),'Table 2'[websites count]=2)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
a new column if that can help
= Calculate(distinctcount(Table[Websites]), filter(Table, [Product] =earlier([Product]) ))
Measure , count of product having 3 websites
Countx(Filter(Summarize(Table, [Product], "_1", distinctcount(Table[Websites])),[_1] =3), [Product])
2
Countx(Filter(Summarize(Table, [Product], "_1", distinctcount(Table[Websites])),[_1] =2), [Product])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
136 | |
111 | |
98 | |
97 | |
92 |