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.
I want to total for 'count of visitors' to be 4424 as its a unique count.
I tried this but it gives a huge number not even close?
User Distinct =
VAR t =
SUMMARIZE (
'Kepler',
Kepler[Date],
"UserDistinct", DISTINCTCOUNT ( Kepler[Visitors] )
)
RETURN
SUMX ( t, [UserDistinct] )
Any help!
Thanks,
Warren
Solved! Go to Solution.
Hi @Anonymous,
You can try this measure:
Measure distinct count visitor = SUMX ( VALUES ( Kepler[Date] ), CALCULATE ( DISTINCTCOUNT ( Kepler[Visitors] ) ) )
Best regards,
Yuliana Gu
@v-yulgu-msftHello,
I want to sum the "Quantite" but with using the discount for "referenceNo" ?
I've tried : qte = calculate(distinctount(tabel[referenceNo]), filter(table,sum(table[quantite]))). But it doesn't work
How can i do it ?
Hi @Anonymous,
You can try this measure:
Measure distinct count visitor = SUMX ( VALUES ( Kepler[Date] ), CALCULATE ( DISTINCTCOUNT ( Kepler[Visitors] ) ) )
Best regards,
Yuliana Gu
Thanks for this!! It works but I am not sure why/how 😅 Just to build on the above, if I wanted to limit to the last 7 days, previous 7 days etc. how would I be able to do that?
Thankyou Yuliana. That's perfect!
Need sample source data in text form that can be copied and pasted. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |