How to count the fields with values in the matrix table?

[Anonymous]

Hi,

I have a matrix table, where I want a measure that gives me the total count of fields with values.

In the below image, we have 37 fields that have values and 11 fields that do no exist. 

Cycles = CALCULATE( DISTINCTCOUNT('TLX Job'[Job No]),'TLX Job'[Job Status] in {"FINISHED", "DELIVERED"})

I know it not possible to calculate the fields which do not exist(11)

How to write a measure that gives 37(fields with values) in this example?

[amitchandak · Accepted solution]

@Anonymous , Try like

countx('TLX Job',[Cycles])
countx(summarize('TLX Job','TLX Job'[Value],'TLX Job'[Date],"_1",[Cycles]),[_1])