topic Re: Parameterized Measure problems in DAX Commands and Tips

Parameterized Measure problems

kaixtae — Thu, 09 Nov 2023 14:35:32 GMT

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?

Re: Parameterized Measure problems

Rupak_bi — Fri, 10 Nov 2023 13:02:53 GMT

please share your working.

Re: Parameterized Measure problems

Anonymous — Tue, 14 Nov 2023 03:15:01 GMT

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