Forum Discussion

Daemetius's avatar
Daemetius
Helper II
9 years ago
Solved

Skip rows with condition using DAX

Greetings,   I'm trying to create a measure with an if statements and some actions.   For example I am looking to create a measure that checks if date column is blank on a row, then that row is s...
Need Help
Tips and Tricks
  • CamFlawless's avatar
    CamFlawless
    9 years ago

    Here is a mock calculation with some sample data I used:

     

    Measure Value = CALCULATE(COUNT(Data[Date]),Data[Date]<>BLANK())
CamFlawless's avatar
CamFlawless
Frequent Visitor
9 years ago

Here is a mock calculation with some sample data I used:

 

Measure Value = CALCULATE(COUNT(Data[Date]),Data[Date]<>BLANK())
AilleryO's avatar
AilleryO
Memorable Member
4 years ago

Hi,

 

I think you do not even need the filter, because COUNT counts only values that are not blank.

So :

COUNT( Data[Date] )

should give you the expected result.

 

Have a nice day