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 am missing values for certain months in my table due to issues onsite at this particular asset. Occassionally this will happen and cannot be avoided. My problem is that this throws off the ratios for "Actual Production / Projected Production" and "Actual Insolation / Projected Insolation". For example, if the Expected Production is missing for January 2021, then I need to exclude the January 2021 Actual Production from the total amount in the table. I still want to display the Actual Production in the table though.
Hi @abrownRPI
Can you show us your DAX formulas?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Actual/Expected Production =
CALCULATE (
DIVIDE ( SUM('Asset_Management_Data'[Actual Production]), SUM('Asset_Management_Data'[Expected Production]) ),
FILTER(Site_Info, Site_Info[Site] <> "LFG")
)
Actual/Projected Insolation =
DIVIDE(
SUM('Asset_Management_Data'[Actual Insolation]),
SUM('Asset_Management_Data'[Projected Insolation])
)
Hi @abrownRPI
It is still hard to catch the issue this way. Can you share your PBIX file please?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi,
Share the link from where i can download your PBI file.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |