Multiplying calculated column values

[jett254]

I'm trying to create a Dashboard and I am a new Power BI user.

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.  This data is reported on a weighted basis so I've done that by using my weight as the value on the graph.  I know this is working because it matches my SPSS results.

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).  This data is not weighted so my value for the chart is just a flag of 1 for every MD.  This graph is filtered to only be those that ordered in graph #1.

So, both of my graphs are fine.  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.

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%.  Any suggestions on how to do this??  This is done by year, so year is on the axis in each graph....

[v-yulgu-msft]

Hi @jett254,

As smoupre suggested, you can directly multiply the current two measures. If the third chart displays the same structure with the 1st and 2nd chart, you can directly add the multiplied measure into 3rd chart.

If this does not apply to your scenario, please share sample data and screenshot of report design to elaborate your requirement more detailedly.

Regards,
Yuliana Gu

[Greg_Deckler]

Are you using measures for % of physicians and % of physicians who ordered a particular formulation? If so, you can just create a third measure that is [Measure1] * [Measure2]