Conditional Formatting Changes and Rows Disappear When Adding Measure to a Table as a Column

[BK12345]

I have a table that is essentially breaking when I add a measure as a column. The table does have a filter context to only display the latest report for a given entity (in the table it is the VISN column).

The main columns of the table are field values (I know this is not necessarily considered optimal), and have conditional formatting set. All works well. (My cursor was over VISN 15, making that row darker)

But when I add the following measure to the table as a column, VISNs 2 and 10 disappear from the table.

-->

If I set the VISN column to 'Show Items with No Data', the rows reappear, but their conditional formatting is gone and the measure is not returning a value.

*Note: I tried changing the conditional formatting from Rules to Field values for the VVC Encounters column. Same result from beginning to end.

Any ideas?

[BK12345]

@amitchandak Thank you so much for your quick response. I found the problem - it was in the data model.

For future reference, table visuals absolutely use measures as columns. The aforementioned measure is the Percent Implemented column in this table.

[amitchandak]

@BK12345 , I doubt you can set a measure as a column, without using segmentation. A measure can not be used as a group directly. 

I doubt a column is getting create which will static in nature

The ways you use the measure as column/dimension

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4