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,
I'm having trouble returning the data in one measure, I want the measure to return me the data in a column that is greater than 0.
Ex: Table 1, cololuna1:
2
1
0
2
1
0
I want to count values that are greater than 0, that in this example the result is 4. And it has to be in a measure.
Thank you.
Solved! Go to Solution.
Hi @strikw,
You need to have something like this:
Count = Calculate ( Count (Table [Colum]), Table [Colum] > 0)
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @strikw,
You need to have something like this:
Count = Calculate ( Count (Table [Colum]), Table [Colum] > 0)
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you very much,
It worked perfectly.
Have a great day.
Att, Paulo Dantas.
Hello,
I'm having trouble returning the data in one measure, I want the measure to return me the data in a column that is greater than 0.
Ex: Table 1, cololuna1:
2
1
0
2
1
0
I want to count values that are greater than 0, that in this example the result is 4. And it has to be in a measure.
Thank you.
Does CALCULATE(COUNTROWS(yourtable), yourcolumn>0) return the result you want?
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |