Forum Discussion
jobf
Helper II
7 months agoMeasure that shows whether the process has been completed
Observe the table with the data below: Plot Date Type Processed Area Total Area P1 2025/01/01 A 12.1 23 P1 2025/01/02 A 10.9 23 P2 2025/01/02 A 10.1 20 P2 2025/01/03 ...
- 7 months ago
jobf I believe that a situation measure like that would look similar to the following:
Situation Measure = VAR _ProcessedArea = SUM( 'Table'[Processed Area] ) VAR _TotalArea = MAX( 'Table'[Total Area] ) VAR _Return = IF( _ProcessedArea = _TotalArea, 1, 0 ) RETURN _Return - 7 months ago
I assume you only have Fact table instead using a star-schema here. If so please try using the measures below in your visual:
First Date = CALCULATE ( MIN ( 'Data'[Date] ), ALLEXCEPT ( 'Data', 'Data'[Plot], 'Data'[Type] ) ) Processed Area (Sum) :+= CALCULATE ( SUM ( 'Data'[Processed Area] ), ALLEXCEPT ( 'Data', 'Data'[Plot], 'Data'[Type] ) ) Total Area (Group) = CALCULATE ( MAX ( 'Data'[Total Area] ), ALLEXCEPT ( 'Data', 'Data'[Plot], 'Data'[Type] ) ) Situation = VAR Proc = [Processed Area (Sum)] VAR Tot = [Total Area (Group)] RETURN IF ( NOT ISBLANK ( Tot ) && Proc >= Tot, "Processed", "Processing" )Visual:
- Fact[Plot]
- [First Date]
- Fact[Type]
- [Situation]
- [Processed Area(Sum)]
- [Total Area]
GeraldGEmerick
Memorable Member
7 months agojobf I believe that a situation measure like that would look similar to the following:
Situation Measure =
VAR _ProcessedArea = SUM( 'Table'[Processed Area] )
VAR _TotalArea = MAX( 'Table'[Total Area] )
VAR _Return = IF( _ProcessedArea = _TotalArea, 1, 0 )
RETURN _Return