Field parameter, data groups

[Anonymous]

Hi!

I have created 2 tables which are supposed to be a base for my field paramters. The tables are identical (the measures are slightly different like :

% Mobile1R Portfolio Total MTD vs 

% Mobile1 Portfolio Total MTD

Table 'KPIs' 

KPIs = {
    ("% Mobile1 Inact. Portfolio Total MTD", NAMEOF('Parc'[% Mobile1 Inact. Portfolio Total MTD]), 0),
    ("% Mobile1 Inact. Portfolio vs LM", NAMEOF('Parc'[% Mobile1 Inact. Portfolio vs LM]), 1),
    ("% Mobile1 Portfolio Total MTD", NAMEOF('Parc'[% Mobile1 Portfolio Total MTD]), 2),
    ("% Mobile1 Portfolio vs LM", NAMEOF('Parc'[% Mobile1 Portfolio vs LM]), 3),
    ("% Mobile2 Inact. Portfolio Total MTD", NAMEOF('Parc'[% Mobile2 Inact. Portfolio Total MTD]), 4),
    ("% Mobile2 Inact. Portfolio Total vs LM", NAMEOF('Parc'[% Mobile2 Inact. Portfolio Total vs LM]), 5),
    ("% Mobile2 Portfolio Total MTD", NAMEOF('Parc'[% Mobile2 Portfolio Total MTD]), 6),
    ("% Mobile2 Portfolio vs LM", NAMEOF('Parc'[% Mobile2 Portfolio vs LM]), 7),
    ("% Email Inact. Portfolio Total MTD", NAMEOF('Parc'[% Email Inact. Portfolio Total MTD]), 8),
    ("% Email Inact. Portfolio Total vs LM", NAMEOF('Parc'[% Email Inact. Portfolio Total vs LM]), 9),
    ("% Email Portfolio Total MTD", NAMEOF('Parc'[% Email Portfolio Total MTD]), 10),
    ("% Email Portfolio vs LM", NAMEOF('Parc'[% Email Portfolio vs LM]), 11),
    ("Recru Quali Mobile1 % MTD", NAMEOF('Recru'[Recru Quali Mobile1 % MTD]), 12),
    ("Recru Quali Mobile1 % vs LM", NAMEOF('Recru'[Recru Quali Mobile1 % vs LM]), 13),
    ("Recru Quali Mobile2 % MTD", NAMEOF('Recru'[Recru Quali Mobile2 % MTD]), 14),
    ("Recru Quali Mobile2 % vs LM", NAMEOF('Recru'[Recru Quali Mobile2 % vs LM]), 15),
    ("Recru Quali Email % MTD", NAMEOF('Recru'[Recru Quali Email % MTD]), 16),
    ("Recru Quali Email % vs LM", NAMEOF('Recru'[Recru Quali Email % vs LM]), 17),
    ("Recru Quali Postal Code % MTD", NAMEOF('Recru'[Recru Quali Postal Code % MTD]), 18),
    ("Recru Quali Postal Code % vs LM", NAMEOF('Recru'[Recru Quali Postal Code % vs LM]), 19),
    ("% Postal Code Inact. Portfolio Total MTD", NAMEOF('Parc'[% Postal Code Inact. Portfolio Total MTD]), 20),
    ("% Postal Code Inact. Portfolio Total vs LM", NAMEOF('Parc'[% Postal Code Inact. Portfolio Total vs LM]), 21),
    ("% Postal Code Portfolio Total MTD", NAMEOF('Parc'[% Postal Code Portfolio Total MTD]), 22),
    ("% Postal Code Portfolio vs LM", NAMEOF('Parc'[% Postal Code Portfolio vs LM]), 23),
    ("Tx Qualif Reabo Mobile1 MTD", NAMEOF('Reabo'[Tx Qualif Reabo Mobile1 MTD]), 24),
    ("Tx Qualif Reabo Mobile1 vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Mobile1 vs LM]), 25),
    ("Tx Qualif Reabo Mobile2 MTD", NAMEOF('Reabo'[Tx Qualif Reabo Mobile2 MTD]), 26),
    ("Tx Qualif Reabo Mobile2 vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Mobile2 vs LM]), 27),
    ("Tx Qualif Reabo Email MTD", NAMEOF('Reabo'[Tx Qualif Reabo Email MTD]), 28),
    ("Tx Qualif Reabo Email vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Email vs LM]), 29),
    ("Tx Qualif Reabo Postal Code MTD", NAMEOF('Reabo'[Tx Qualif Reabo Postal Code MTD]), 30),
    ("Tx Qualif Reabo Postal Code vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Postal Code vs LM]), 31)
}

The groups have been created (1. Portfolio, 2. Inactives etc.)

Table 'KPIs Real'

KPIs Real = {
    ("% Mobile1R Inact. Portfolio Total MTD", NAMEOF('Parc'[% Mobile1R Inact. Portfolio Total MTD]), 0),
    ("% Mobile1R Inact. Portfolio vs LM", NAMEOF('Parc'[% Mobile1R Inact. Portfolio vs LM]), 1),
    ("% Mobile1R Portfolio Total MTD", NAMEOF('Parc'[% Mobile1R Portfolio Total MTD]), 2),
    ("% Mobile1R Portfolio vs LM", NAMEOF('Parc'[% Mobile1R Portfolio vs LM]), 3),
    ("% Mobile2R Inact. Portfolio Total MTD", NAMEOF('Parc'[% Mobile2R Inact. Portfolio Total MTD]), 4),
    ("% Mobile2R Inact. Portfolio Total vs LM", NAMEOF('Parc'[% Mobile2R Inact. Portfolio Total vs LM]), 5),
    ("% Mobile2R Portfolio Total MTD", NAMEOF('Parc'[% Mobile2R Portfolio Total MTD]), 6),
    ("% Mobile2R Portfolio vs LM", NAMEOF('Parc'[% Mobile2R Portfolio vs LM]), 7),
    ("% Email R Inact. Portfolio Total MTD", NAMEOF('Parc'[% Email R Inact. Portfolio Total MTD]), 8),
    ("% Email R Inact. Portfolio Total vs LM", NAMEOF('Parc'[% Email R Inact. Portfolio Total vs LM]), 9),
    ("% Email R Portfolio Total MTD", NAMEOF('Parc'[% Email R Portfolio Total MTD]), 10),
    ("% Email R Portfolio vs LM", NAMEOF('Parc'[% Email R Portfolio vs LM]), 11),
    ("Recru Quali Mobile1R % MTD", NAMEOF('Recru'[Recru Quali Mobile1R % MTD]), 12),
    ("Recru Quali Mobile1R % vs LM", NAMEOF('Recru'[Recru Quali Mobile1R % vs LM]), 13),
    ("Recru Quali Mobile2R % MTD", NAMEOF('Recru'[Recru Quali Mobile2R % MTD]), 14),
    ("Recru Quali Mobile2R % vs LM", NAMEOF('Recru'[Recru Quali Mobile2R % vs LM]), 15),
    ("Recru Quali Email R % MTD", NAMEOF('Recru'[Recru Quali Email R % MTD]), 16),
    ("Recru Quali Email R % vs LM", NAMEOF('Recru'[Recru Quali Email R % vs LM]), 17),
    ("Recru Quali Postal Code R % MTD", NAMEOF('Recru'[Recru Quali Postal Code R % MTD]), 18),
    ("Recru Quali Postal Code R % vs LM", NAMEOF('Recru'[Recru Quali Postal Code R % vs LM]), 19),
    ("% Postal Code R Inact. Portfolio Total MTD", NAMEOF('Parc'[% Postal Code R Inact. Portfolio Total MTD]), 20),
    ("% Postal Code R Inact. Portfolio Total vs LM", NAMEOF('Parc'[% Postal Code R Inact. Portfolio Total vs LM]), 21),
    ("% Postal Code R Portfolio Total MTD", NAMEOF('Parc'[% Postal Code R Portfolio Total MTD]), 22),
    ("% Postal Code R Portfolio vs LM", NAMEOF('Parc'[% Postal Code R Portfolio vs LM]), 23),
    ("Tx Qualif Reabo Mobile1R MTD", NAMEOF('Reabo'[Tx Qualif Reabo Mobile1R MTD]), 24),
    ("Tx Qualif Reabo Mobile1R vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Mobile1R vs LM]), 25),
    ("Tx Qualif Reabo Mobile2R MTD", NAMEOF('Reabo'[Tx Qualif Reabo Mobile2R MTD]), 26),
    ("Tx Qualif Reabo Mobile2R vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Mobile2R vs LM]), 27),
    ("Tx Qualif Reabo Email R MTD", NAMEOF('Reabo'[Tx Qualif Reabo Email R MTD]), 28),
    ("Tx Qualif Reabo Email R vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Email R vs LM]), 29),
    ("Tx Qualif Reabo Postal Code R MTD", NAMEOF('Reabo'[Tx Qualif Reabo Postal Code R MTD]), 30),
    ("Tx Qualif Reabo Postal Code R vs LM", NAMEOF('Reabo'[Tx Qualif Reabo Postal Code R vs LM]), 31)
}

The groups have been created exactly the same way (1. Portfolio, 2. Inactives etc.).

For the table 'KPIs' my field parameter works fine. By filtering the slicer by the group name eg. 1. Portfolio I receive the values corresponding with that group. 

However, for the table 'KPIs Real' I receive only the name of the measures. 

Could you please give me any tips what am I doing wrong?

The only difference I noticed is the existence of the question marks in KPIs fields. 

And the fact that values for KPI Real are set as rows in the table visual . However, for KPI they are set as cols.

[Anonymous]

Hi @johnbasha33 ! 
Thank you for your time & reply. 

1. The measures naming checked : they are written correctly. They are all highlighted in violet (which means PBI recognizes them). 

2. Data format exactly the same in both tables. 

3. Both tables don't have any relationships. The relationship are applicable for the tables that the measures are based on. 

4. Everything's okay here.

5. The measures have been checked independently. They display exactly what they are expected to visualize.

What is interesting, while copying KPIs table and recreating exactly the same table (same measures and everything) named KPIs2 we face the same issue like with KPIs Real. 

[johnbasha33]

@Anonymous 

It seems like you're encountering an issue with your field parameters when using the 'KPIs Real' table compared to the 'KPIs' table in Power BI. From your description and screenshots, it appears that the measures are displayed correctly when using the 'KPIs' table, but only the measure names are displayed when using the 'KPIs Real' table.

The difference you noted about the existence of question marks in the KPIs fields may be significant. The question marks might indicate that the corresponding measures are not recognized or resolved correctly by Power BI.

Here are a few suggestions to troubleshoot and potentially resolve the issue:

1. **Check Measure Names**: Ensure that the measure names in the 'KPIs Real' table are correctly defined and recognized by Power BI. Make sure there are no syntax errors or missing references in the measure names.

2. **Data Type and Format**: Verify that the data types and formats of the measures in the 'KPIs Real' table are consistent and compatible with Power BI's requirements. Incorrect data types or formats could cause issues with data recognition and display.

3. **Table Relationships**: Double-check the relationships between the 'KPIs Real' table and other relevant tables in your Power BI model. Ensure that the relationships are correctly established and that the measures are associated with the appropriate tables and fields.

4. **Field Formatting**: Check the formatting settings for the field parameter slicer and the table visual. Make sure that the field parameter slicer is configured to display the appropriate field values and that the table visual is set up to display the selected measures correctly.

5. **Testing Measures**: Test individual measures from the 'KPIs Real' table to see if they return the expected results when added to the table visual directly, without using the field parameter slicer. This can help identify any issues specific to certain measures.

6. **Review DAX Expressions**: Review the DAX expressions used to define the measures in the 'KPIs Real' table. Look for any errors or inconsistencies in the expressions that could be causing the measures not to be resolved correctly.

By carefully reviewing these aspects and making any necessary adjustments, you should be able to resolve the issue with your field parameters and ensure that the measures from the 'KPIs Real' table are displayed correctly in Power BI.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!