Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I've the following pbix https://1drv.ms/u/s!Amd7BXzYs7AVlXPjuP0CfblYyc5K?e=kNnEiN
I've the following measure
Solved! Go to Solution.
Hi, @Anonymous,
it is because this part of your measure
VAR dt = SELECTEDVALUE ( 'DimDate'[date] )
returns blank for the total.
Try rewriting the measure like this:
Measure2 =
VAR _1 =
MAX ( MaxPropre[Nb] ) + 0
VAR _maxMaxPropreDate =
CALCULATE ( MAX ( MaxPropre[Date] ), ALL ( DimDate ) )
VAR _min =
MIN ( 'Date Filter'[date] )
VAR _max =
MAX ( 'date Filter'[Date] )
VAR dt =
SELECTEDVALUE ( 'DimDate'[date] )
VAR _result =
IF (
MIN ( 'DimDate'[Date] ) < _min
|| MAX ( 'DimDate'[Date] ) > _max,
BLANK (),
IF ( _maxMaxPropreDate >= VALUES ( DimDate[Date] ), [const], 0 )
)
VAR _total =
SUMX (
CALCULATETABLE (
VALUES ( DimDate[Date] ),
FILTER ( ALL ( DimDate ), DimDate[Date] >= _min && DimDate[Date] <= _max )
),
IF (
_maxMaxPropreDate >= CALCULATETABLE ( VALUES ( DimDate[Date] ) ),
[const],
0
)
)
RETURN
IF ( HASONEVALUE ( DimDate[Date] ), _result, _total )
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi, @Anonymous,
it is because this part of your measure
VAR dt = SELECTEDVALUE ( 'DimDate'[date] )
returns blank for the total.
Try rewriting the measure like this:
Measure2 =
VAR _1 =
MAX ( MaxPropre[Nb] ) + 0
VAR _maxMaxPropreDate =
CALCULATE ( MAX ( MaxPropre[Date] ), ALL ( DimDate ) )
VAR _min =
MIN ( 'Date Filter'[date] )
VAR _max =
MAX ( 'date Filter'[Date] )
VAR dt =
SELECTEDVALUE ( 'DimDate'[date] )
VAR _result =
IF (
MIN ( 'DimDate'[Date] ) < _min
|| MAX ( 'DimDate'[Date] ) > _max,
BLANK (),
IF ( _maxMaxPropreDate >= VALUES ( DimDate[Date] ), [const], 0 )
)
VAR _total =
SUMX (
CALCULATETABLE (
VALUES ( DimDate[Date] ),
FILTER ( ALL ( DimDate ), DimDate[Date] >= _min && DimDate[Date] <= _max )
),
IF (
_maxMaxPropreDate >= CALCULATETABLE ( VALUES ( DimDate[Date] ) ),
[const],
0
)
)
RETURN
IF ( HASONEVALUE ( DimDate[Date] ), _result, _total )
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi @sturlaws
When I try to calculate nextday for Measure2, it dosen't work, coul you please help me ? thank you very much
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |