Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mikaelhyensjo
Frequent Visitor

DAX with dimension data (min or max)

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])

 

 

 

1 ACCEPTED SOLUTION
LaurentCouartou
Solution Supplier
Solution Supplier

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]
)

 

 

View solution in original post

1 REPLY 1
LaurentCouartou
Solution Supplier
Solution Supplier

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]
)

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors