Forum Discussion

databubble's avatar
databubble
Frequent Visitor
9 years ago

Boolean measure breaks relationship?

Hi   I have tables DimSalesperson and FactSales. They are related by SalesPerson   DimSalesperson: Salesperson TargetTotalSales Amit 4000 Barbara 5000 Carolina 6000 Deng 7000...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

databubble

 

Hi, applied a visual filter and will work.

 

databubble's avatar
databubble
Frequent Visitor
9 years ago

Hi

 

Thank you for helping with my problem.

 

I see a filter gives the results I want, but it feels like a workaround to a problem in my measure. I am new to Power BI and not sure what is good practice! Is it usual to generate and filter out the "wrong" results ?

 

Liz

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    databubble,

    Generally, we don’t drag SalesPerson fields of both table to create a visual. We only drag SalesPerson field from either DimSalesperson table or FactSales table to visuals in Power BI, this way, expected result will return.

    Regards,