Dynamic Column Variance Based on Year Selected with Slicer

[Joe6654]

I am relatively new to Power BI. I have a table that brings back the count of the number of controls tested per year based on the years selected in the slicer. I want to create a variance column next to the two years selected that automatically calculates the variance based on the years selected in the slicer.

For instance, for the view listed below, I want to see a variance for each control tested with the total amounting to 167. If I change the years, the variance would change accordingly.

[v-yuta-msft]

Hi Joe6654,

Create a measure use DAX like below and try again:

Measure =
CALCULATE ( aggregation, ALLSELECTED ( table[Year] ) )

Regards,

Jimmy Tao

[Joe6654]

Thank you for your response.  I tried the fix but it did not work.

[v-yuta-msft]

Hi Joe6654,

Use a table chart instead and put the measure in the chart and try again.

Jimmy Tao

[Joe6654]

Jimmy,

Thanks for your response.  When I switch to the table chart I still get an error.