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.
i have a Dax formula that I use successfully in a bar chart with region data, BUT when i try to use it with a different category (Countries) it "cant display the visual"... im having trouble trying to troubleshoot the source of the error, can someone take a look? https://1drv.ms/u/s!AiL3mI_trBnxgxDFo4oupkQnbvFU
Solved! Go to Solution.
HI @ilcaa72
Your formula is fine, the problem is your data is causing the function to overflow. If you wrap some crude error handling around your RETURN statement as follows
return iferror(if (blank(),0,((SubNow/Sub6yrsAgo)^(1/3))-1),"Has Error")
You will see that two rows have issues
Neither of these has a value for the Sub6yrsAgo, so the divide fails
Another option is to use the DIVIDE function to gracefully handle the issue
return if (blank(),0,(DIVIDE(SubNow,Sub6yrsAgo,blank())^(1/3))-1)
HI @ilcaa72
Your formula is fine, the problem is your data is causing the function to overflow. If you wrap some crude error handling around your RETURN statement as follows
return iferror(if (blank(),0,((SubNow/Sub6yrsAgo)^(1/3))-1),"Has Error")
You will see that two rows have issues
Neither of these has a value for the Sub6yrsAgo, so the divide fails
Another option is to use the DIVIDE function to gracefully handle the issue
return if (blank(),0,(DIVIDE(SubNow,Sub6yrsAgo,blank())^(1/3))-1)
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 |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |