Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |