Aurea Quantra
Power BI · synthetic demo · manufacturing & distribution scenario
Synthetic demo Saturday, November 21, 2026 11:43 AM All demos Consulting page Book My BI Diagnostic

Platform demo · Power BI delivery

Measure explorer: certified DAX vs sandbox drafts

Browse a synthetic semantic model—certified measures, draft sandbox formulas, RLS role dimming, and a report-page map that jumps into executive and sales tabs.

How this maps to Power BI

Power BI consulting: models, DAX, governance, and executive dashboards.

  • Certified vs draft measures with DAX-like expressions
  • RLS role toggle that dims customer exposure
  • Report page map into multi-tab navigation
  • AI insight grounded in the same model Power BI Q&A would need curated
Filters Invoice scope
Server CSV

Filters apply to revenue charts and the first two KPIs. Other tabs use the full demo model. Use Copy link to share this view.

Power BI measure explorer

Certified vs draft measures with DAX-like expressions — synthetic semantic model.

Aurea Quantra is independent. No partnership with Microsoft is claimed; product names belong to their owners.

Illustrative pattern · synthetic data

Stack

  1. Source systems
  2. Power Query
  3. Semantic model
  4. Certified measures
  5. Reports
  6. RLS roles

Illustrative pattern · synthetic data

Certified measures

8

Illustrative pattern · synthetic data

Draft measures

3

Illustrative pattern · synthetic data

Folders

4

Illustrative pattern · synthetic data

Illustrative pattern · synthetic data

Measures per display folder

Illustrative pattern · synthetic data

Certified vs draft measures

Illustrative pattern · synthetic data

KPI recipe: gross margin % DAX

Gross Margin % =
DIVIDE (
    SUM ( fact_invoices[gross_margin] ),
    SUM ( fact_invoices[revenue] )
)

Illustrative pattern · synthetic data

Semantic objects

ObjectTypeNotes
bridge_crm_erp_keysSemantic model tablebridge
dim_channelSemantic model tabledimension
dim_customerSemantic model tabledimension
dim_dateSemantic model tabledimension
dim_productSemantic model tabledimension
dim_regionSemantic model tabledimension
dim_sales_repSemantic model tabledimension
fact_inventory_backlogSemantic model tablefact
fact_invoicesSemantic model tablefact
fact_opportunitiesSemantic model tablefact
fact_opportunity_stage_histSemantic model tablefact
fact_sales_ordersSemantic model tablefact
fact_samplesSemantic model tablefact
Total RevenueDAX measurecertified · Finance
Revenue YTDDAX measurecertified · Finance
Gross MarginDAX measurecertified · Finance
Gross Margin %DAX measurecertified · Finance
Open BacklogDAX measurecertified · Operations
Pipeline ValueDAX measurecertified · Sales
Weighted PipelineDAX measurecertified · Sales
Sample Conversion %DAX measurecertified · Sales
Draft Channel MixDAX measuredraft · Sandbox
Uncertified Discount GuessDAX measuredraft · Sandbox
Bookings vs Billings GapDAX measuredraft · Sandbox

Illustrative pattern · synthetic data

Data-quality checks

Computed from the demo tables when the app loads them. “warn” marks mismatches this scenario includes on purpose.

CheckTableRows checkedFlaggedStatus
Invoices have a customer key fact_invoices 22,000 0 pass
Invoice customer keys exist in dim_customer fact_invoices 22,000 0 pass
Invoice product keys exist in dim_product fact_invoices 22,000 0 pass
Invoice dates exist in dim_date fact_invoices 22,000 0 pass
Invoice revenue is not negative fact_invoices 22,000 0 pass
Gross margin does not exceed revenue fact_invoices 22,000 0 pass
Opportunity customer keys exist in dim_customer fact_opportunities 4,500 0 pass
Customer keys are unique dim_customer 500 0 pass
Customers matched between CRM and ERP dim_customer 500 90 warn
Every month 2023-01..2026-12 has invoices fact_invoices 48 0 pass

Illustrative pattern · synthetic data

Measures

  • Total Revenue certified Finance SUM(fact_invoices[revenue])
  • Revenue YTD certified Finance CALCULATE([Total Revenue], DATESYTD(dim_date[date]))
  • Gross Margin certified Finance SUM(fact_invoices[gross_margin])
  • Gross Margin % certified Finance DIVIDE([Gross Margin], [Total Revenue])
  • Open Backlog certified Operations SUM(fact_inventory_backlog[open_order_value])
  • Pipeline Value certified Sales SUM(fact_opportunities[opportunity_value])
  • Weighted Pipeline certified Sales SUMX(fact_opportunities, [opportunity_value]*[probability])
  • Sample Conversion % certified Sales DIVIDE([Converted Samples], [Samples Shipped])
  • Draft Channel Mix draft Sandbox SUMX(VALUES(dim_channel[channel]), [Total Revenue])
  • Uncertified Discount Guess draft Sandbox AVERAGE(fact_invoices[revenue])*0.12
  • Bookings vs Billings Gap draft Sandbox [Pipeline Value]-[Total Revenue]

Illustrative pattern · synthetic data

How to present this

  • Toggle RLS role to dim the customer list — illustrates workspace role patterns, not live Power BI RLS.
  • Report page map jumps to the matching dashboard tab.
  • Draft measures stay in Sandbox until governance certifies them.

Illustrative pattern · synthetic data

What the AI insight is told about this platform

Platform lens: Power BI measure explorer. Emphasize certification, DAX, and RLS—not metro/PulseGrid.

The model also receives the synthetic KPIs, the current invoice slice and the semantic model summary.