Forum Discussion

batman's avatar
batman
Icon for Helper I rankHelper I
1 year ago
Solved

Field Parameter assistance

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 u...
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    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()
    )
    )
    )
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.