Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone, I have been presented with a very particular case. contextualize a little:
I have a column called Adults, when I start by observing that this column is formatted as "Text" so I decide to change it to Integer.
According to, I proceed to highlight the sum of Adults that are in the table SUM (Table [adults]), but when performing the Sum gives me 0, I tried to calculate the number of adults -Calculate (CountA (Table [Adults]), Table [adult]> 0), the result is White,
I tried Calcualte (Table [Adult]), It gives me a tip but it is not the real one. in the excel table corroborates that the amount or count is 500 and with the formula exposed gives me 200. I don't know what could be going 😞
@Syndicate_Admin
I guess you are creating measures, try add all(table) to the context, as well as for the sum.
Calculate (CountA (Table [Adults]), Filter (All(table), Table [adult]> 0)
calculate (SUM (Table [adults]),All(Table))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@Syndicate_Admin ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try like
countrows(Filter(Table, Table [adult]> 0))
or
countrows(Filter(Table, isblank(Table [adult]) || Table [adult]<> 0))
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |