How to count a column resulting from a measure/calculation

[Syndicate_Admin]

Hello everyone,

I am wanting to do a count of a specific column that is the result of a Measure that results in a TEXT:

Detail:

Highest Pharmacy = IF(IF(CALCULATE(COUNT(Data[Price Seniors]),Data[Price Seniors]>0)>1,CALCULATE(.MAX(Data[Price Seniors])),"Not Captured")="Not Captured","Not Captured",IF([But High]=Calc_Kielsa[Kielsa],"Kielsa",IF([But High]=Calc_Siman[Siman],"Siman",IF([But High]=Calc_FA[FA],"FA","Not Captured"))))

and what I want to do is a count of how many times FA appears in that calculation/column

[v-stephen-msft]

Hi @OlmatrixHN504 ,

You can create a measure to count like

Count FA = COUNTROWS(FILTER(ALLSELECTED('Table'),[Highest Pharmacy]="FA"))

Best Regards,

Stephen Tao

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

[Syndicate_Admin · Accepted solution]

Good morning.

Thanks for responding.

It did not work, because the comlumna of [Farmacia Más Alta], is the result of an Expression (measure, Calculation), which using COUNT (I needed a COUNTIF of an expression) was not going to work according to the suggested formula.

Which solution was solved in two steps:

1) First step; Count per row, which the formula is: FA> = IF([Highest Pharmacy]="FA",1,0)

2) Second step; Add those counts with: Measure= SUMX(ALLSELECTED(Data[Product]),Calc_FA[FA>])

This solved the problem for me, I hope it will serve you all.