Forum Discussion
dd88
Post Patron
2 years agoIn 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 ...
- 2 years ago
Hi,
These measures should be dragged to a card visual
Measure1 = counta(Data[Quality issue])
Measure2 = counta(Data[Status])
dd88
Post Patron
2 years agoapologies Ritaf1983 TomMartens
I have reread my orginial post, and I accidentally uploaded screen capture version 1. I have updated and uploaded screen capture to version 2. Hoping this makes it clear.
Column Quality Issue, to count all values and not include blanks
Another count for Column Status to count all values and not include blanks
thank you again ..
Ashish_Mathur
Super User
2 years agoHi,
These measures should be dragged to a card visual
Measure1 = counta(Data[Quality issue])
Measure2 = counta(Data[Status])
- dd882 years ago
Post Patron
Yes all good Ashish_Mathur Many thanks that worked
- Ashish_Mathur2 years ago
Super User
You are welcome.