Forum Discussion

Adrian_A's avatar
Adrian_A
Frequent Visitor
3 years ago
Solved

DAX String to define Blanks

So,

 

I'm new to Power Bi and that includes Dax. I am starting to understand strings that are predefined but need some help with a logical return of the table filtered. What i am trying to express in a Dax is below:

 

 See table All columns but filters based on Blank Rows in specific column. I don't know if this would be considered a measure, calculate or a filter if that's possible.

This is what i think makes since?? (below is not DAX just a theory i'm hoping someone can make since of)

 

Filter Table = How many([Column],Jobs1, has [Column],Exteriors Approved3.[Filter Table].[Blank],Rows Only in [Column],Exteriors Approved3))

 

The goal is to see only the rows with Blanks in a column(Exteriors Approved) but, still see all other data for same rows across all columns

So Columns: how many (Jobs,1) has (Exteriors Approved,3) with BLANK Rows = Filtered Table                               

 

Table before Filter

 | Jobs1  | Data 2 |Exteriors Approved3 |Data4 |Data5|

   X                X                     X                    X          X    

   X                X                  BLANK                         X      

   X                X                     X                                      

 

Table After :

| Jobs1  |  Data2 |   Exteriors Approved3 |   Data4 |  Data5|

 

   X              X                   BLANK                                  X    

 

I hope that makes since and any help is greatly appreciated😓 

  • Hi, Adrian_A ;

    You could create a measure as follow:

    Measure = COUNTROWS(FILTER('Table',[Exteriors Approved3]=BLANK()))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies