Page Navigation with Conditional Formatting Bug

[Asking4Help]

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 Field Value in my Navigation Table it does not allow me to select the option. 

I have tested this and re-created the issue multiple times. I started a brand new file, with no data connections - and was able to successfully accomplish what I was trying to do. 

When trying to do this to a file that I have been working on for months is when the issue occurs. I saved a version of this file, deleted all of the data connections and the issue is still occuring. I also checked all settings in both files. 

Does anyone have the answer to this issue? I do not want to have to re-create the file with hundreds of measures and re-build my entire report. 

[Asking4Help]

This was a great explanation and very clear. I removed the calculation group - as it was not necesary and was able to correct the issue. 
Thank you so much!

[OwenAuger · Accepted solution]

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?