Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Selected Value and If Statement

 I want to have the state selected show up as a title for the report, but if there is no selected state, I want it to just say USA. Any help would be greatly appreciated, as I have just begun to use power BI

Need Help

1 Reply

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    3 years ago

    Anonymous ,

    try this,

    Selected country =
IF (
    HASONEVALUE ( financials[Country] ) = TRUE (),
    MAX ( financials[Country] ),
    "USA"
)

    Thanks,

    Arul