Need help with calculating in aggregate

Question

I'm trying to create a Dashboard and I am a new Power BI user.&nbsp;I've created two different bar graphs -- one shows the % of physicians who ordered a particular drug (the data has one record per MD, and has an "Ordered" field that is a string with Yes/No. &nbsp;This data is reported on a weighted basis so I've done that by using my weight as the value on the graph. &nbsp;I know this is working because it matches my SPSS results.&nbsp;I have a second bar graph that shows the % of physicians who ordered a particular formulation of the drug (same table, a different variable that is a string Yes/No). &nbsp;This data is not weighted so my value for the chart is just a flag of 1 for every MD. &nbsp;This graph is filtered to only be those that ordered in graph #1.&nbsp;So, both of my graphs are fine. &nbsp;Now I need to create another graph or table that multiplies the % that ordered * the % that ordered the particular formulation together, on an aggregate basis.&nbsp;So if in graph one, it was 60% ordered (40% did not) and graph 2 was (50% ordered that form/50% did not), I need to produce a graph that is 60% * 50% = 30%. &nbsp;Any suggestions on how to do this?? &nbsp;This is done by year, so year is on the axis in each graph....

anonymous · Answer

Unclear if you wrote measures for the values in the first 2 graphs. &nbsp;Probably best if you did. &nbsp;And I'm not sure how your model looks, but you could image something like:&nbsp;Total Physicians = COUNTROWS(Physicians)Total Ordering Physicians = CALCULATE([Total Physicans], FILTER(Physicians, SUM(Orders[Quanity]) &gt; 0))% ThingOne = DIVIDE ([Total Physicians], [Total Ordering Physicians])&nbsp;% ThingTwo = ... however you do that... :)&nbsp;% ThingOneThingTwo = [% ThingOne] * [% ThingTwo]&nbsp;&nbsp;

Forum Discussion

Related content

Aggregate XIRR Calculation Help

Calculate previous month aggregate amount

Data Aggregation issue

Monthly averages - Calculated column - Aggregation

Calculated Column with aggregate window partition