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 using if(hasonevalue( to be able to roll up a matrix and display different values in PBI. THe activities are all under the category
If(hasonevalue(activity),measure1,sumx(table(measure1)
This sumx is giving an error that the value is too big - why is this and how can it be resolved?
Hi @sparkplug93751 ,
Please share me a dummy PBIX file, removing sensitive information, for specific test.
Best Regards,
Icey
@sparkplug93751 your syntax of expression look completely wrong, is that what your measure is? What error you are getting? Can you provide more detail?
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi,
I'm getting a "Value was either too large or too small" error. The numbers are in the millions but all together there isn't a value over 175,000,000 (and that's the total of all categories). I was able to get close to the desired answer by using
calculate(measure1),groupby(table1,table1[categories]),userelationship(table1[categories],table2[categories]
But rather than summing up to make the total per category it is still using the hours and time to calculate the measure aggregated up - an aggregation I want to be just a sum rather than the numbers
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |