Measures or KPI

[harveychun]

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?

[Walter_C]

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

[harveychun]

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]

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...