Forum Discussion
Microsoft Fabrics Semantic Model - Calculation group
Hello
I have created calculation group with three measure
calculation group --> 'Measure selection'
Turnover = SUM(sales[turnover])
net_sales= SUM(sales[net])
gross_sales= SUM(sales[gross])
selectedMeaure = SELECTEDMEASURE()
Slicer:
Field --> 'Measure selection'
Matrix visual --> Rows: Product Name , Columns: Measure selection, Values: SelectedMeasure
The matrix visual is displaying all three measures even if none are selected in the slicer. I need to change this behavior so that the matrix visual only shows measures when they are selected; otherwise, it should display only the product names.
can someone point me where i'm doing wrong ?
thanks
1 Reply
- lbendlinSuper User
You forgot to enable the "Force selection" setting.
By default "Nothing selected" is equivalent to "Everything selected".