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 ,

 

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.

  • jasonh2hdigital's avatar
    jasonh2hdigital
    Regular Visitor
    5 years ago

    Thanks Anonymous ,

     

    I suspected it had something to do with a filter.  Nice work.  

     

    If I wanted to filter the main report on date, what would I need to reflect this is the measure?

     

    I played with ALLEXCEPT but not getting any sucess.  Any suggestions appreciated.