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 Everyone,
I have used Subtotal from Distinctcount in the table and the result is incorrect. I used 2 measures for the calculation below.
visit(cal) = DISTINCTCOUNT(Spending[date])
Visit = VAR _table = SUMMARIZE(Spending, Spending[member_number], "distinctcount", DISTINCTCOUNT(Spending[date]))
RETURN
SUMX(_table, [visit(cal)])
The result of subtotal should be (14+24+46) = 84 but in the table shown 83. Please help me to fix it.
Solved! Go to Solution.
Hi @runatthakorn ,
Refer the below ,according your provided,similar question:
2+2 ,get total:3
You need to create a new measure:
test = if(HASONEVALUE(Spending[branch_name]),[visit(cal)],SUMX(DISTINCT(Spending[branch_name]),[visit(cal)]))
Output:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi,
Share the link from where i can download your PBI file.
Hi @runatthakorn ,
Refer the below ,according your provided,similar question:
2+2 ,get total:3
You need to create a new measure:
test = if(HASONEVALUE(Spending[branch_name]),[visit(cal)],SUMX(DISTINCT(Spending[branch_name]),[visit(cal)]))
Output:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
you may have a similar id in rows between two categories, So as your formula is distinct count it counts it only once.
can we have a your data set to verify ?
Hi FerhatLyes,
Thank you for your reply and for the sample of data set as below.
I want to use distinct count of date group by member_number and group by branch_name.
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 |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |