Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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?

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , Try like

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