Forum Discussion

c_avu's avatar
c_avu
Frequent Visitor
1 year ago

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

  • You forgot to enable the "Force selection"  setting.

     

    By default "Nothing selected"  is equivalent to "Everything selected".