Forum Discussion

Asking4Help's avatar
Asking4Help
New Member
1 year ago
Solved

Page Navigation with Conditional Formatting Bug

Hello,    I am trying to incorporate Page Navigation using a Button and a slicer. I created the table and when attempting to set the Conditional Formatting for the Button Action to be based on the ...
  • OwenAuger's avatar
    1 year ago

    Hi Asking4Help 

    In the file where it's not working, it looks like the model property "Discourage Implicit Measures" is set to True (docs).

    When set to "Yes", Power BI Desktop won't allow you to create "implicit measures". Implicit measures are measures created by selecting a column then choosing an aggregation type from a drop-down or context menu, without explicitly writing DAX.

     

    This setting can be enabled manually but is usually forcibly enabled when a calculation group is added to the model, and must be manually disabled even if all calculation groups are removed.

    Recommendation:

    1. Create an explicit measure, such as

     

    Destination =
    SELECTEDVALUE ( 'Nav 2'[Page] )

     

     

    or

     

    Destination =
    MIN ( 'Nav 2'[Page] )

     

    and use this as the destination.

     

    2. Disable Discourage Implicit Measures if you can.

     

    Do any of these work for you?