Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |