Divide and Represent a Parameter Output

Hello Anonymous,

To divide the result of your parameter into three sections and represent them in an interactive way, you can use a combination of measures, slicers, and visualizations.

1. Create a measure that calculates the percentage of the total value for each of the three sections:

Section 1 % = 
VAR Total = [A+X]
VAR Section1 = CALCULATE([A+X], [A+X] > 0.5)
RETURN DIVIDE(Section1, Total)

Section 2 % = 
VAR Total = [A+X]
VAR Section2 = CALCULATE([A+X], [A+X] > 0.25 && [A+X] < 0.5)
RETURN DIVIDE(Section2, Total)

Section 3 % = 
VAR Total = [A+X]
VAR Section3 = CALCULATE([A+X], [A+X] < 0.25)
RETURN DIVIDE(Section3, Total)

2. Create a slicer that allows you to select the value of [Valore Parametro]. You can use a "Numeric Range" slicer for this.

3. Create a pie chart or three simple counters to represent the three sections. For example, for the pie chart, you can use the three measures created above as the values and the section names as the categories. For the counters, you can use the three measures as the values and add a title to each counter to indicate the section name.

4. Link the slicer to the measures and the visualizations. You can do this by selecting the slicer, going to the "Visualizations" pane, and setting the "Visual interactions" to "Highlight" for the measures and the visualizations.

This should allow you to create an interactive dashboard that allows you to visualize the distribution of values based on the [Valore Parametro] parameter and the three sections defined.

Let me know if you might require further assistance.