I would like a slicer from a field parameter table to show certain calculation group items

[Kasonga2018]

Hi Have a matrix that show calculation group items such as Current value, MoM relative Change and MoM Absolute change as column header and rows as a email type. I also have a slicer from a field parameter for Total Member, Rates1 and Rates2

What I woulike to achieve is, if I select Total Member on the slicer, the matrix must only show Current Value items and MoM relative Change. and if I select Rates1 or Rate2 it must only show Current Value and MoM Absolute change. Is this possible?

Please note that my field parameter is indeed added on my matrix on the value filed

[OwenAuger · Accepted solution]

Hi @Kasonga2018 

Here is one type of method I've applied in similar situations, with an example PBIX attached.

The basic steps I applied are:

1. Create a table that relates the Field Parameter values to Calculation Items. In my example, I used the "Order" column to identify the Field Parameter, since the visible Field Parameter column cannot be used on the 1-side of a relationship.
2. Create a relationship between the Field Parameter and this new table, so that filtering the Field Parameter filters this table.
3. Create an additional Calculation Group with Calculation Item that blanks out measure values unless the combination of Field Parameter & Measure exists in the table in step 1.
4. Apply this new Calculation Item as a filter on the visual.

The end result is that filtering the field parameter effectively filters the calculation items (by blanking out unwanted calculation items).

Some additional screenshots:

Step 1: 'Measure Calc Item' table

Step 2: Relationship between Field Parameter and 'Measure Calc Item':

Step 3: New Calculation Group (TE3 DAX script):

------------------------------------------------
-- Calculation Group: 'Filter Time Intelligence'
------------------------------------------------
CALCULATIONGROUP 'Filter Time Intelligence'[Filter]    Precedence = 1

    CALCULATIONITEM "Filter based on Field Parameter" = 
        VAR RequiredCalcItems =
            VALUES ( 'Measure Calc Item'[Calcuation Item] )
        VAR CurrentCalcItem =
            SELECTEDVALUE ( TimeIntelligence[Time Calc] )
        VAR DisplayMeasure = CurrentCalcItem IN RequiredCalcItems
        RETURN
            IF ( DisplayMeasure, SELECTEDMEASURE ( ) )

Does something like this work for you?

Regards,

[Kasonga2018]

Hi all, is there anyone willing to help please? Basically, I just need to control what column from the calculation groups items to show on the matrix based on my slicer selection (Slicer is a field parameter for measures)