# DAX Calculations with Invalid Boolean Predicates

2019-04-17

Whenever you start trying to use more complicated filters in the CALCULATE or CALCULATETABLE functions in DAX, you may start to get the following error:

A function ‘MAX’ has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Read on for Eugene’s explanation and what you can do about it.

## Using Semi-Additive Measures with DAX

2019-04-02

Alberto Ferrari explains what semi-additive measures are and how we can work with them in DAX: First things first: what is a semi-additive calculation? Any calculation can be either additive, non-additive or semi-additive. An additive measure uses SUM to aggregate over any attribute. The sales amount is a perfect example of an additive measure. Indeed, […]

## Counting Working Days with DAX

2019-03-14

Alberto Ferrari shows how we can ignore weekends in date calculations with DAX: How is it possible to compute the difference between the two dates, only computing working days and skipping weekends and holidays? Simple math is no longer useful here, and DAX does not offer a predefined function. A solution to this scenario requires […]

This site uses Akismet to reduce spam. Learn how your comment data is processed.

April 2019
MTWTFSS
« Mar
1234567
891011121314
15161718192021
22232425262728
2930