DAX Measure: Calculate count distinct users filtered by measure for selected time period

[yjetti_gps]

Hi,

Need Help

I am new to DAX and PBI need help calucating a measure.

Calculate count distinct users with sum(sales) >100 during the filtered period. please help ne achive this one.

Output Example:

State	# users (Spent > 100)
California	300
Texas	250
New York	150

Dimensions:

State

User

Calander 

Fact:

Sales

[Anonymous]

Hi @yjetti_gps ,

According to the information, I could not infer which field is associated between these tables.

Please upload some data samples and expected output.Please do mask sensitive data before uploading.

Best Regards,

Eyelyn Qin

[mahoneypat]

Assuming you have a measure called [Spend] (that sums up your Fact table), you can use a measure like this to get the count of users the spent >100.

Users Over 100 =
COUNTROWS ( FILTER ( VALUES ( Table[User] ), [Spent] > 100 ) )

Replace Table with your actual table name.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat