Table Cannot Display When Add Measure From Another Table

[UncleLewis]

Hi all,

I imported all of my data sources and created all relationships.

I added a Table Vis to the canvas and started adding Fields

I added 9-10 Fields with no issue

As soon as I added a measure to the table it is saying Can't Display The Visual

I added a new Page

I added a Table Vis
I added the Serial Number to the Table

I added the Repair Count Measure to the Table

Everything works as expected.

Why is that?

Thanks,

-w

[v-shex-msft]

Hi @UncleLewis,

Any update on this? If you are still confused about handling your requirement, can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[UncleLewis · Accepted solution]

The Bridge Table was not giving me the expected results.
I created a new Dim Table and made a unique key by concatenating Serial Number with Work Order
Now that my model is straightened out - everything works as expected.

Thanks

w

[UncleLewis]

I think I might have a bad data model.
I used a bridge table to join various id fields through the bridge

I'm rebuilding the data model without the bridge table to see if it clears things up.

I'll come back if I still have problems

Thanks

-w

[Samarth_18]

HI @UncleLewis ,

Could you please share the error which you are getting with sample data in text format(not a screenshot) and expected output. Also share the code which you have written in a measure.

Thanks,

Samarth