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 made a power BI report to calculate some stats on some large lab data, which is broken down by test name (e.g., CRP, TBI), material (e.g., 193201/3) and machine (e.g., line 1, line 2). The means, SD, CV and N= are calculated parameters from the data set
I have a 2nd report page summarising the results for each test, for each material:
What I really need to do now, is a calculation off the report values, i.e., CV (for 193201) x CV (for 193203) for each test. Is there any way to do this? I could export the table to excel but ideally i want to do it all in power Bi without opening up mtliple report templates. I am very much a novice in Power BI - any help appreciated!
Yes - thats it. I cannot work our how to do it. The calculation doensnt seem to work in the table, when i creat a new meausure. CV is already a measure and I now need to calculate another parameter off the CV result but on the sliced data results of that measure. Hope this makes sense.
Hi @mitchemmonkey ,
Sorry I'm not very clear about your expected result. Do you want a new column to calculate the CV (for 193201) multiply CV (for 193203)?
Best Regards,
Community Support Team _ kalyj
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.