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
Hi.
I have the following formula and its working.
CALCULATE([Total_Quantity];Fact_Forecast_Received[Type]=1;Fact_Forecast_Received[Current date]="2016-02-01")
Will now use selection box to select two dates = Current date and then use the min and max function to create two
columns. One with the max value selected and one with min value selected.
I have tried to use min and max like below with now success.
CR_min = min(Fact_Forecast_Received[Current date])
CALCULATE([Total_Quantity];Fact_Forecast_Received[Type]=1;Fact_Forecast_Received[Current date]=[CR_min])
Solved! Go to Solution.
You probably received the following message: "A CALCULATE function was used in a TRUE/FALSE expression as a table filter. This is not allowed".
Note that
CALCULATE( someExpression ; Table[Column] = someConstant )
is a shortcut for
CALCULATE( someExpression ; FILTER( ALL(Table[Column]) ; [Column] = someConstant ) )
However, if you use a measure to filter your data, you need to write the full filter expression:
FILTER( ALL(Fact_Forecast_Received[Current date]); [Current date]=[CR_min] )
You probably received the following message: "A CALCULATE function was used in a TRUE/FALSE expression as a table filter. This is not allowed".
Note that
CALCULATE( someExpression ; Table[Column] = someConstant )
is a shortcut for
CALCULATE( someExpression ; FILTER( ALL(Table[Column]) ; [Column] = someConstant ) )
However, if you use a measure to filter your data, you need to write the full filter expression:
FILTER( ALL(Fact_Forecast_Received[Current date]); [Current date]=[CR_min] )
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 |
---|---|
114 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |