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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi jasonh2hdigital ,

 

Sorry for that the information you have provided is not making the problem clear to me.

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

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.