created calculated field from summarized dataNested DAX QueryCalculate daily targets based on monthly targets Sales Power biPower BI: Opportunity model (relating 3 tables)Expanding Zip Codes From County Level For Multiple Vendorscalculated column function similar to returning customer measure in DAXPower BI Query Error: The column either doesn't exist or doesn't have a relationship to any table available in the current contextPower BI Rank within Matrix VisualIssue trying to calculate gradient using Power BIPowerBI - Filtered Table in a Cell of another TableFilter by two criteria
Tesco's Burger Relish Best Before End date number
What does the multimeter dial do internally?
How to use Adostop Eco stop bath?
How do I explain that I don't want to maintain old projects?
Who goes first? Person disembarking bus or the bicycle?
Is this car delivery via Ebay Motors on Craigslist a scam?
A ring of generalized power series
My professor has told me he will be the corresponding author. Will it hurt my future career?
3-way switches no longer serving their purpose
Can you create a free-floating MASYU puzzle?
The Apéry's constant and the Airy function
How many Jimmys can fit?
How did the IEC decide to create kibibytes?
What are the effects of abstaining from eating a certain flavor?
Array or vector? Two dimensional array or matrix?
Interpretation of non-significant results as "trends"
Computer name naming convention for security
Passwordless authentication - how and when to invalidate a login code
Chilling water in copper vessel
Curly braces adjustment in tikz?
How to understand flavors and when to use combination of them?
Four ships at the ocean with the same distance
How can a person with a similar experience with the defendant, help the plaintiff in a lawsuit?
Is "wissen" the only verb in German to have an irregular present tense?
created calculated field from summarized data
Nested DAX QueryCalculate daily targets based on monthly targets Sales Power biPower BI: Opportunity model (relating 3 tables)Expanding Zip Codes From County Level For Multiple Vendorscalculated column function similar to returning customer measure in DAXPower BI Query Error: The column either doesn't exist or doesn't have a relationship to any table available in the current contextPower BI Rank within Matrix VisualIssue trying to calculate gradient using Power BIPowerBI - Filtered Table in a Cell of another TableFilter by two criteria
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
This question is regarding PowerBI and DAX. I have two tables relevant to this question. The first a customer list, including addresses. The second is a geospatial reference table. The reference table has the square mileage of various zip codes. I'm looking to create a density field, which would be the number of customers in a zip code divided by the sq/mi of that zip code. I feel like this is a two-step process, first summarizing the customer count by zip, and then calculating the density. I can't seem to figure out a way of doing it outside of creating another table. Is this something I can do on the fly? I ask because my customer list will change frequently enough that creating that intermediate table could be a bit of an issue.
powerbi dax
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
add a comment |
This question is regarding PowerBI and DAX. I have two tables relevant to this question. The first a customer list, including addresses. The second is a geospatial reference table. The reference table has the square mileage of various zip codes. I'm looking to create a density field, which would be the number of customers in a zip code divided by the sq/mi of that zip code. I feel like this is a two-step process, first summarizing the customer count by zip, and then calculating the density. I can't seem to figure out a way of doing it outside of creating another table. Is this something I can do on the fly? I ask because my customer list will change frequently enough that creating that intermediate table could be a bit of an issue.
powerbi dax
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
add a comment |
This question is regarding PowerBI and DAX. I have two tables relevant to this question. The first a customer list, including addresses. The second is a geospatial reference table. The reference table has the square mileage of various zip codes. I'm looking to create a density field, which would be the number of customers in a zip code divided by the sq/mi of that zip code. I feel like this is a two-step process, first summarizing the customer count by zip, and then calculating the density. I can't seem to figure out a way of doing it outside of creating another table. Is this something I can do on the fly? I ask because my customer list will change frequently enough that creating that intermediate table could be a bit of an issue.
powerbi dax
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
This question is regarding PowerBI and DAX. I have two tables relevant to this question. The first a customer list, including addresses. The second is a geospatial reference table. The reference table has the square mileage of various zip codes. I'm looking to create a density field, which would be the number of customers in a zip code divided by the sq/mi of that zip code. I feel like this is a two-step process, first summarizing the customer count by zip, and then calculating the density. I can't seem to figure out a way of doing it outside of creating another table. Is this something I can do on the fly? I ask because my customer list will change frequently enough that creating that intermediate table could be a bit of an issue.
powerbi dax
powerbi dax
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
asked Mar 25 at 22:15
ShabzShabz
113 bronze badges
113 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Is it not simply:
Density =
DIVIDE (
COUNTROWS ( 'Customer Table' ),
SUM ( 'Geospatial Reference Table'[Area] ),
BLANK()
)
With a relationship between Customer Table and Geospatial Reference Table on field Zip
Here's a worked example PBIX file: https://pwrbi.com/so_55347190/
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347190%2fcreated-calculated-field-from-summarized-data%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is it not simply:
Density =
DIVIDE (
COUNTROWS ( 'Customer Table' ),
SUM ( 'Geospatial Reference Table'[Area] ),
BLANK()
)
With a relationship between Customer Table and Geospatial Reference Table on field Zip
Here's a worked example PBIX file: https://pwrbi.com/so_55347190/
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
add a comment |
Is it not simply:
Density =
DIVIDE (
COUNTROWS ( 'Customer Table' ),
SUM ( 'Geospatial Reference Table'[Area] ),
BLANK()
)
With a relationship between Customer Table and Geospatial Reference Table on field Zip
Here's a worked example PBIX file: https://pwrbi.com/so_55347190/
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
add a comment |
Is it not simply:
Density =
DIVIDE (
COUNTROWS ( 'Customer Table' ),
SUM ( 'Geospatial Reference Table'[Area] ),
BLANK()
)
With a relationship between Customer Table and Geospatial Reference Table on field Zip
Here's a worked example PBIX file: https://pwrbi.com/so_55347190/
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
Is it not simply:
Density =
DIVIDE (
COUNTROWS ( 'Customer Table' ),
SUM ( 'Geospatial Reference Table'[Area] ),
BLANK()
)
With a relationship between Customer Table and Geospatial Reference Table on field Zip
Here's a worked example PBIX file: https://pwrbi.com/so_55347190/
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
edited Mar 26 at 10:12
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
answered Mar 26 at 9:54
OllyOlly
5,4291 gold badge11 silver badges30 bronze badges
5,4291 gold badge11 silver badges30 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347190%2fcreated-calculated-field-from-summarized-data%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
