topic Re: Field Parameter assistance in DAX Commands and Tips

Field Parameter assistance

batman — Mon, 07 Oct 2024 18:44:44 GMT

Hello,

I need some assistance with field paramters, I created a field parameter called "OTF," which essentially allows toggling between two flags with values of "Yes" and "No." I want to enable users to select either Field A or Field B, and then choose between "Yes" or "No." In this case we are selecting a No in the calculation.

I'm trying to write a calculation as follows:

CountRowsNum =
COUNTROWS(
FILTER(
TableName,
TableName[AnotherFlag] = "N" && SELECTEDVALUE('Parameter[OTF]') = "N"
)
)

The goal is to count rows where "AnotherFlag" is 'N' and the selected OTF is also 'N,' while allowing users to switch between Field A and Field B.

Thanks

Re: Field Parameter assistance

Kedar_Pande — Tue, 08 Oct 2024 05:26:08 GMT

DAX calculation:

CountRowsNum = 
COUNTROWS(
FILTER(
TableName,
TableName[AnotherFlag] = "N" &&
SWITCH( 
TRUE(),
SELECTEDVALUE('Parameter[OTF]') = "Field A", TableName[FieldA] = "N",
SELECTEDVALUE('Parameter[OTF]') = "Field B", TableName[FieldB] = "N",
FALSE()
)
)
)

Re: Field Parameter assistance

Anonymous — Thu, 10 Oct 2024 06:05:28 GMT

Hi batman ,

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution.

If it doesn't resolve, please provide sample data. We can better understand the problem and help you.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Field Parameter assistance

batman — Thu, 17 Oct 2024 13:12:55 GMT

That seems to work, Thank you