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 need to create a table similar to the following:
with month as row and different measures as column or even better the measures as row. The reason is that I want to use the measures as a filter and see their values in a single chart.
Each measure is obtained by subtracting two addittional measures that combine multiple tables:
for example, the Tubes Margin is:
TUBE REVENUES =
VAR Tube = CALCULATE (SUM ('*PRICE'[€ TUBES]))
Solved! Go to Solution.
@Luca2020 Hi,
You can create a calculation group using tabular editor in this case.
And then create calculation items for each measure and deploy the model so that you can use measures as columns or rows.
(About Calculation Group, you can refer to this article)
Mark this post as solution if this helps, thanks!
@Luca2020 Hi,
You can create a calculation group using tabular editor in this case.
And then create calculation items for each measure and deploy the model so that you can use measures as columns or rows.
(About Calculation Group, you can refer to this article)
Mark this post as solution if this helps, thanks!
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |