Microsoft Fabrics Semantic Model - Calculation group

c_avu — Tue, 17 Sep 2024 16:13:23 GMT

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

Re: Microsoft Fabrics Semantic Model - Calculation group

lbendlin — Tue, 17 Sep 2024 22:12:09 GMT

You forgot to enable the "Force selection" setting.

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

topic Re: Microsoft Fabrics Semantic Model - Calculation group in Developer

Microsoft Fabrics Semantic Model - Calculation group

Re: Microsoft Fabrics Semantic Model - Calculation group