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 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!
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |