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 ...
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

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.