Forum Discussion

jasonh2hdigital's avatar
jasonh2hdigital
Regular Visitor
5 years ago
Solved

SWITCH TRUE doesn't return when table relationship

I have a basic Power BI report with three tables.   ReportFormat (1 to many) ReportChart (1 to many) GL   ReportFormat provides a structure I want for a financial report. ReportChart provids...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi jasonh2hdigital ,

     

    Please take a look at the following output based on the relative fields from the three tables:

    You could rewrite the original measure Filter(ALL('GL')  like this:

    Measure = 
COUNTAX(FILTER(ALL('GL'),RELATED('ReportChart'[ReportItemsNormalised]) IN {"Total Income"}),[Amount])

    Then the result works fine:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.