topic Name Columns Parameter table don't understand filters context in DAX Commands and Tips

Name Columns Parameter table don't understand filters context

Anonymous — Wed, 26 Apr 2023 11:58:43 GMT

Hi everyone!

I am trying to change dynamically the name of columns in a Parameter Table that I created. The issue is that this names understand DAX formula, but filters context don't apply on them. If I filter a field which is taking part in these expressions, nothing is changing.

Anyone could help me? Is there any solution?

Thanks in advance!

Re: Name Columns Parameter table don't understand filters context

lbendlin — Fri, 28 Apr 2023 02:14:20 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Name Columns Parameter table don't understand filters context

Anonymous — Fri, 05 May 2023 10:34:43 GMT

Thank you for your help.

I am trying to provide a simple example.

Imagine we have this table:

Country	Product Type
Spain	1
France	1
Spain	1
Spain	2

I want to create a table that is only shown if an unique value of country is selected (this is not a problem). Furthermore, I create two measures, which count the number of each type product.

I have another table:

Country	Product Type	Label
Spain	1	Producto A
Spain	2	Producto B
France	1	Produit A

I need to create a parameter table to select which of these measures are being shown in the table. The problem is that I want the label of these measure change accordgin to the table.

I am trying to use an expression in the parameter table but it is not taking into account the selections in the model.

Thank you again.