This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi All,
Please find the below table. I am getting infinity when I divide eventhough it's just a simple division.
Please help.
Hi @Kolumam,
Do above columns come from the same data table? Which two columns do you refer to to make a division? Please share the necessary DAX formulas.
Regards,
Yuliana Gu
Yes it comes from the same column. The column name is PR. The only thing that differentiates the PR is the reference name.
Hi @Kolumam,
Without sample data and necessary formulas, it's hard to check the reason for getting infinity result.
Regards,
Yuliana Gu
If you see the table column heading , it's self explanatory. It is doing divison.
Hi @Kolumam,
Is [Total PR] an original column in source table or calculate column or measure? And what about [Irradiation]? Please check whether this article is helpful to you.
Maybe you could try this:
=IFERROR(
[Mesaure 1]/[Mesaure 2],
BLANK()
)
Regards,
Yuliana Gu
Hi,
Share the link from where i can download your file.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 65 | |
| 41 | |
| 28 | |
| 22 | |
| 22 |