Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
and what I want to do is a count of how many times FA appears in that calculation/column
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |