Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I know there is a similar topic in the thread but I couldn't achieve what I wanted following the solution (maybe because my data model is different). Basically what I need is to divide one column by another in the matrix (actual vs target).
Please click the link to the pbix file
and the picture of the matrix itself that I want to achieve.
Really appreciate your help!
Solved! Go to Solution.
Hi @powerbiuser444 ,
Please refer to my .pbix file.
In addition, I used the "Sort by column" feature in the calculation table below.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @powerbiuser444 ,
Please refer to my .pbix file.
In addition, I used the "Sort by column" feature in the calculation table below.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-lionel-msft thanks for your time. Unfortunately, when I add slicers for Campaign and Agents, your measure doesn't recalculate. The numbers for SPH and Target vs Actual are static. Is it possible to modify the measures so the numbers are recalculated based on what Campaign and Agent selected?
Unfortunately, with the data model you have, it is not posisble to insert the calculated column the way you want. Suggest to insert the Traget vs ACtual values in the dataset itself (i.e. calcluate in the source itself). Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |