Forum Discussion
Need help with calculating in aggregate
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...
Unclear if you wrote measures for the values in the first 2 graphs. Probably best if you did. And I'm not sure how your model looks, but you could image something like:
Total Physicians = COUNTROWS(Physicians)
Total Ordering Physicians = CALCULATE([Total Physicans], FILTER(Physicians, SUM(Orders[Quanity]) > 0))
% ThingOne = DIVIDE ([Total Physicians], [Total Ordering Physicians])
% ThingTwo = ... however you do that... :)
% ThingOneThingTwo = [% ThingOne] * [% ThingTwo]