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

I think I would need more context into what you are trying to compute. Getting DAX/Power BI to move over the rows with (Blank) values is easy enough, but providing a comprehensive solution requires more information from you. 

Daemetius's avatar
Daemetius
Helper II
9 years ago
CamFlawless wrote:

I think I would need more context into what you are trying to compute. Getting DAX/Power BI to move over the rows with (Blank) values is easy enough, but providing a comprehensive solution requires more information from you. 

This is basically to show an amount of system incidents occurred over a period of 1 month (all this is an example). Then throw it into a bar graph that shows the number of issues on that month but skips those without a date. so if there are total of 20 rows and 3 have empty dates then the graph would show 17 instead of 20.

  • 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