Forum Discussion

dd88's avatar
dd88
Icon for Post Patron rankPost Patron
2 years ago
Solved

In a column 2 seperate Counts for count all items and count blanks

User requirements are for a column, count total items and total blank items. The purpose is to know the blanks and then action and fill in the gaps.   The 2 seperate columns are Quality Issue and ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    These measures should be dragged to a card visual

    Measure1 = counta(Data[Quality issue])

    Measure2 = counta(Data[Status])

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi dd88 
The question isn't entirely clear, so I'll try to guess. If the goal is just to count, since I see it's text, in the first step, I would replace the 'white spaces' with NULL in Power Query, because it's not the same thing from the engine's perspective.

After closing and applying you can create 2 simple measures for blanks and not blanks:

Cont non balanks = (COUNTA('Table'[Column]))
Count blanks = COUNTBLANK('Table'[Column])

The pbix with the example is attached

If it is something else 

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly