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.
Hi Team,
I have a column with both numbers & Text. Is there a way to sum only numeric values in that column using a single measure?
Eg:
I have a table like shown below. I need a measure to show the sum of total events as 12(by adding 7 & 5 in cnt column).
Thanks in advance!
Solved! Go to Solution.
Hi @AmudhaKumaran ,
Please create a calculated column to check only for numeric data as below
Thereafter create a measure to sum the column
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos..!
Regards
Husna
Hi @AmudhaKumaran ,
Please create a calculated column to check only for numeric data as below
Thereafter create a measure to sum the column
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos..!
Regards
Husna
Hi @Anonymous ,
Thanks for yor response. What you suggested would absolutely work for a standalone dataset. However, I'm using a data model that is in datalake and I don't manage it. Means, I cannot create columns. I can only create measures withing my report.
So that's why I'm trying to figure out my issue using a measure.
@AmudhaKumaran , I would advise to create a new numeric column in power query
refer: https://www.youtube.com/watch?v=YtCFAxD5qow
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |