Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Data:
Date | Group | Reg | Plt | Mat | $ | Qty |
11/1/2023 | PDC | K | u1 | m1 | 1 | 9 |
12/2/2023 | PDC | N | u2 | m2 | 3 | 5 |
2/2/2024 | PD | N | u3 | m3 | 4 | 6 |
3/3/2024 | PD | N | u4 | m4 | 5 | 8 |
4/4/2024 | PD | K | u1 | m1 | 6 | 7 |
5/5/2024 | Date | N | u2 | m2 | 8 | 1 |
6/4/2024 | Date | K | u5 | m5 | 9 | 4 |
7/5/2024 | Date | N | u4 | m4 | 7 | 2 |
8/9/2024 | Date | K | u7 | m7 | 2 | 3 |
Measure:
Value $ =
When i use any visual, and just have Date and Value $, everything is okay and works as it should. Once i bring in any other detail into the visual, the numbers are all wrong.
Any help is appreciated.
You can use SUMMARIZE to adjust to potential other filters. But that still means you need separate measures.
Value $ =
VAR b =
ADDCOLUMNS (
SUMMARIZE ( Data, [Date Label],[Reg] ),
"md", CALCULATE ( MAX ( Data[Date] ) )
)
VAR c =
ADDCOLUMNS (
b,
"s",
IF (
[Date Label] IN { "PD", "PDC" },
CALCULATE ( SUM ( Data[$] ) ),
VAR md = [md]
var r = [Reg]
RETURN
CALCULATE (
SUM ( Data[$] ),
ALL ( Data ),
Data[Date] <= md,
Data[Reg] = r,
Data[Group] = "Date"
)
)
)
RETURN
IF ( HASONEVALUE ( Data[Date Label] ), SUMX ( c, [s] ), SUMX ( Data, [$] ) )
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |