cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Measures or KPI

harveychun
New Contributor

With Databricks BI, Is there anyway to create a KPI or Measures that can be used in a visual? If so, how to achieved that one?

3 REPLIES 3

Walter_C
Databricks Employee
Databricks Employee

Can you please provide some more context on your current usecase?

Hi @Walter_C 

I am just figuring out if possible in databricks.

Let say for example I have a Measure in Power BI or a formula in Thoughtspot and wanted to move it to databricks XYZ = (sum(x) + sum(y))/z

I wanted to use that XYZ formula/measure in a visual either by vendor or by product or by category. XYZ data will dynamically change depending on grouping or filters applied. 

I am thinking of whatever I have in Power BI and Thoughtspot, I can translate to Databricks and users can just directly use it in databricks without having to do data model in power bi and create measures in power bi. Wanted to have everything in Databricks 

szymon_dybczak
Esteemed Contributor III

Hi @harveychun ,

You can try to use AI/BI dashboards in Databricks SQL. There is a good article written by Cody Austin Davis that shows how combination of parameters and filters allows to create dynamic reports.
But keep in mind that reproducing complex DAX measures in Databricks SQL can be complicated and that the capabilities of databricks dashboards (which are getting better) are still pretty limited comparing to Power BI. 

Building Lakeview Dashboards on Databricks โ€” Best Practices | by Databricks SQL SME | DBSQL SME Engi...

 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group