If HasoneValue giving unrealistic values

[sparkplug93751]

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?

[Icey]

Hi @sparkplug93751 ,

Please share me a dummy PBIX file, removing sensitive information, for specific test.

Best Regards,

Icey

[parry2k]

@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

[sparkplug93751]

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