Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need a measure in the table that sum the sales with the cutoff date, that is, the last date of the segmenter and that in the table I add up and show me only what is in the red box, not the rest , the rest should not appear or show the values os sales at 0. In this case, for example, only the three items that are from July 13, which is the last date selected. Keep in mind that it is a flat table, there are no dates dimensions.
Solved! Go to Solution.
Hi, @mrbajana ;
You could create a measure as follows:
Measure =
IF (
MAX ( [Caiday] ) = CALCULATE ( MAX ( [Caiday] ), ALLSELECTED ( 'Table' ) ),
CALCULATE (
SUM ( [Uit veta] ),
FILTER ( ALLSELECTED ( 'Table' ), [Caiday] = MAX ( [Caiday] ) )))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @mrbajana ;
You could create a measure as follows:
Measure =
IF (
MAX ( [Caiday] ) = CALCULATE ( MAX ( [Caiday] ), ALLSELECTED ( 'Table' ) ),
CALCULATE (
SUM ( [Uit veta] ),
FILTER ( ALLSELECTED ( 'Table' ), [Caiday] = MAX ( [Caiday] ) )))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |