Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following dataset that includes a date, a store ID, and a profit value for that month. One site has not compiled it's report yet for the time frame:
Date | ID | Profit |
10/1/2019 | 1 | -25 |
10/1/2019 | 2 | 24 |
10/1/2019 | 3 | 0 |
10/1/2019 | 4 | |
10/1/2019 | 5 | -1 |
11/1/2019 | 1 | 34 |
11/1/2019 | 2 | 14 |
11/1/2019 | 3 | 3 |
11/1/2019 | 4 | |
11/1/2019 | 5 | -5 |
My goal is to countthe number of sites in a given time period that are profitable. Profitable in this case is anything that is greater than or equal to 0. My current measure for this is as follows:
Solved! Go to Solution.
Positive Values = SUMX(
SUMMARIZE(
FILTER(
Table,
NOT(ISBLANK(Table[Profit]))
),
Table[ID]
),
IF(CALCULATE(SUM(Table[Profit])) >= 0, 1 , BLANK()))
Proud to be a Super User!
Positive Values = SUMX(
SUMMARIZE(
FILTER(
Table,
NOT(ISBLANK(Table[Profit]))
),
Table[ID]
),
IF(CALCULATE(SUM(Table[Profit])) >= 0, 1 , BLANK()))
Proud to be a Super User!
Thank you very much!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |