visual calculations

2 Topics

Visual Calculation using FIRST()
Hi Folks, I have data for some suppliers and prices for a material: Supplier Date NetPrice SUP1 28.02.2024 20,66 SUP1 29.02.2024 20,66 SUP2 01.03.2024 16,95 SUP2 02.03.2024 16,95 SUP2 03.03.2024 16,95 SUP2 04.03.2024 16,95 SUP2 05.03.2024 19 SUP2 06.03.2024 19 I want to show where the price was going up or down per supplier. The user wants to see this in an indexed line chart something like this: you can see that also the supplier changed so it is basically calculated Calculation = [Average of NetPrice] / FIRST([Average of NetPrice]) But when I do this in a visual calculation it doesn't work. Apperantly FIRST() does not respect the legend (even with the parameters for sorting blank values last). So it takes the first date of all suppliers. but for my second supplier the first value is then blank. this is why i get infinity values Any ideas on that?
Solved
Lanceometer
1 year ago Place DAX Commands and Tips
649Views
0likes
1Comment
Visual calculations only uses fields in the visual?
Hi - I have been testing the new "Visual Calculations" feature for use cases where I need to apply filter conditions on individual measures inside a table. However, it seems to be limited to only fields/columns present in the visual itself and cannot use other fields in the model. For example, I need to produce a table with the measure [Revenue] and then immediately next to it display [Revenue] filtered for just one department (the unfiltered [Revenue] measure sums revenue from ALL departments). There is no other way to generate this result without creating a second custom measure in the model for [Revenue - Specific Department]; I was hoping to accomplish this with a single measure using visual calculations and applying the filter condition for the one department on the [Revenue] measure as the second column in a visual calculation. But this does not seem possible because the [Department] field needs to actually be incorporated into the visual for it to be used; this results in a change to the table itself slicing by [Department] which was not the result I need. Is there any way in visual calculations to use columns not present in the visual? And if not, is that on the roadmap?
Solved
mbbozzuto
2 years ago Place DAX Commands and Tips
2.2KViews
0likes
4Comments