Forum Discussion
Page Navigation with Conditional Formatting Bug
- 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?
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!