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.
I'm very new to BI and have only vague familiarity with pivottables, so my question is likely to seem very naive.
I have a data table, which I think is pivot table and BI friendly, i.e., each row is unique but may have duplicative data from a different row. So the data is Project A, B, C, and then Setup Costs by A, B, C and Sales for each Quarter for each Project.
I'm trying to create a Card Visual in BI that shows Setup Costs, but since each row of information includes Setup Costs, it's over-summing the unique values.
So I want the Card Visual output to be 275 [=50 + 100 + 125] but instead is outputting 1100, which is the full sum of the Setup Costs column
Project | Setup Costs | Quarter | Sales |
A | 50 | 1 | 5 |
A | 50 | 2 | 10 |
A | 50 | 3 | 15 |
A | 50 | 4 | 20 |
B | 100 | 1 | 5 |
B | 100 | 2 | 10 |
B | 100 | 3 | 15 |
B | 100 | 4 | 20 |
C | 125 | 1 | 10 |
C | 125 | 2 | 20 |
C | 125 | 3 | 30 |
C | 125 | 4 | 40 |
Solved! Go to Solution.
I think I have what you're looking for. To be clear, the 1100 is expected from PowerBI. If I were you, I would consider another data structure (e.g. separate tables) for this if possible, but if you can't, you can work around it. You could always do something simple like:
I think I have what you're looking for. To be clear, the 1100 is expected from PowerBI. If I were you, I would consider another data structure (e.g. separate tables) for this if possible, but if you can't, you can work around it. You could always do something simple like:
Thanks very much. That worked. I was also able to eventually set the "Visual Level Filter" to "Quarter is 1", and thought I had tried that initially before posing the query but wasn't able to "apply filter" - it had been greyed out.
Thanks again!
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |