article thumbnail

Understanding The “A Measure Is Used In Cross Highlighting” Error In Power BI

Chris Webb BI

To do this, take the following basic Power BI dataset: There are two products in the Product table – Apples and Oranges – and two countries in the Country table – UK and France, plus some sales values in the fact table.

Matrix 339
article thumbnail

An SDR’s Field Guide to Sales Territory Mapping

Zoominfo

Sales territory maps serve as the game boards for outside sales, which makes field sales reps the game board pieces. Though it can be tedious, sales territory mapping provides a framework for strategic planning — ensuring that sales reps don’t go into meetings blind. What is Sales Territory Mapping?

Sales 264
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

DAX Measures That Never Return Blank

Chris Webb BI

Now let’s say your boss says she hates all that white space in the matrix and wants to see zeroes instead. The obvious way to fix this is to add a zero to the result of the count in the measure, like so: Count Of Sales = COUNTROWS('Property Transactions')+0 It’s a minor change so what could go wrong? What is a blank value?

Matrix 305
article thumbnail

SplashBI is recognized as a Leader in Everest Group’s 2024 People Analytics Platform PEAK Matrix® Assessment

Splash BI

SplashBI is recognized as a Leader in Everest Group’s 2024 People Analytics Platform PEAK Matrix® Assessment [Duluth, Georgia, 11th April] – SplashBI has been recognized as one of the Leaders in Everest Group’s 2024 People Analytics Platform PEAK Matrix® Assessment. April 10, 2024

Matrix 116
article thumbnail

Dynamic What-If With User-Entered Data In Power BI

Chris Webb BI

Here’s an Import mode fact table containing sales values for various products: The aim is to allow end users to enter one or more percentage values in a report and have these used to calculate growth forecasts on the Sales Amount value. Let’s see a simple example of how to do this.

Matrix 316
article thumbnail

An Important Guide To Unsupervised Machine Learning

Smart Data Collective

Clustering is a go-to grouping method in various industries: Marketing and sales – for predicting customer behavior (personalization and targeting). Singular Value Decomposition (SVD) is an effective method widely used for working with the matrix. Clustering methods are among the simplest algorithms used in unsupervised ML.

Learning 363
article thumbnail

Practical advice to optimize savings with cloud migrations

CIO

Among those chat participants suggested: Will the senior consultants you sent on the sales call be doing the technical work or will you substitute cheaper, more junior consultants? Every cloud service provider (CSP) has a roles & responsibilities matrix. Tell me in detail of similar migrations you’ve done.

Matrix 420