How to count in a measure

IgorGoncalves21 — Tue, 10 Jan 2023 20:34:20 GMT

Hello,
I'm looking for solve this problem :

Count each result in this measure :

If(calculate(Count(FAT_MUDANCA_FASE_PRODUCAO_CONIPA[producao_numero]), DIM_GRUPO_FASE_PRODUCAO_CONIPA_DESTINO[grupo_fase_producao_nome] IN {"MODELAGEM", "CQ BORRACH"}) > 0, "3", If(SUM(FAT_MOVIMENTACAO_MOLDE_CONIPA[m_quantidade_movimento_ajustado]) = 0 || SUM(FAT_MOVIMENTACAO_MOLDE_CONIPA[m_quantidade_movimento_ajustado]) , "1", If(SUM(FAT_MUDANCA_FASE_PRODUCAO_CONIPA[m_quantidade]) / SUM('FAT_MOVIMENTACAO_MOLDE_CONIPA'[m_quantidade_movimento_ajustado]) > 300 , "2", "4" )))

Last Collum :

So , reach how many are in numer 1 for exemple

Re: How to count in a measure

tamerj1 — Tue, 10 Jan 2023 21:38:40 GMT

Manually insert a single column table that contains the values of the 4 possible results of the measure. Let's call it FilterTable.
Place FilterTable[Result] in a table visual along with following measure

CountMeasure =
SUMX (

VALUES ( FAT_MUDANCA_FASE_PRODUCAO_CONIPA[producao_numero] ),

IF (

[Measure] = SELECTEDVALUE ( FilterTable[Result] ),

)

topic How to count in a measure in DAX Commands and Tips

How to count in a measure

Re: How to count in a measure