Parameterized Measure problems

[kaixtae]

Hi!

I have created a parameter with 5 measures inside. I use it to change the columns of my table dynamically. Inside each measure is a condition where if there is no selected date, the measure will display the values for the max date. The measure works just fine. I tested it with and without adding it to the parameter.

1. When not added in the parameter, the measures can display the maximum date effectively.

2. When added, the measures get the KPIs' max date and return more values than expected.

I think the problem is in the parameter. Has anyone encountered this issue before?

[v-shex-msft]

Hi @kaixtae ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Rupak_bi]

please share your working.