Forum Discussion
Analyze in Excel
When I choose 0L in Ledger it filters the Ledger Name column from the other table in Power BI. Relationship is applied in both tables. But when I analyze the data in excel, Ledger Filtering of CVM_AC_Ledger table doesn’t appear to be working correctly. When filtering CVF_GL_Balances to the 0L ledger and adding the Ledger Name to the table, the GL Balance filter doesn’t filter the AC Ledger table values. Only the value for “Leading Ledger” should appear not all Ledger Names.
I am having this exact issue. Data model in Power BI has a Customer Group look up table. Connected to a customer order info table by Customer Group Code (CG look up 1 to * Customer Order Info). Customer Order Info is then connected to Customer Address Info by Customer Number (Cust Order Info 1 to 1 Cust Address Info). In Power BI, I can pull Customer Names from Cust Address Info and Filter with a Slicer on the Customer Group Look Up, it works no problem. When I analyze this data model in Excel, I cannot filter Customer Address Info by Customer Group Look Up.