Based on your query "I want SAA I and SAA O," I’ll assume you’re asking for a breakdown of transactions in your dataset where "SAA I" and "SAA O" refer to specific conditions, and you want metrics like the number of transactions and total value for each. Since no specific metrics were provided, I’ll interpret "SAA I" as transactions where the T_FROMAPPLI column equals "SAA" and the I_O column equals "I" (Input), and "SAA O" as transactions where T_FROMAPPLI equals "SAA" and I_O equals "O" (Output). I’ll provide a step-by-step guide to achieve this in Power BI, along with results based on the sample data.

Understanding "SAA I" and "SAA O"

• SAA I: Transactions where T_FROMAPPLI = "SAA" and I_O = "I".
• SAA O: Transactions where T_FROMAPPLI = "SAA" and I_O = "O".
• Metrics: Since you didn’t specify, I’ll provide:
  • Number of Transactions: Count of rows matching each condition.
  • Total Value: Sum of the AMOUNT column for those rows.

This interpretation aligns with the dataset’s structure, where T_FROMAPPLI indicates the application source (e.g., "SAA") and I_O indicates the transaction direction (Input or Output).

Step-by-Step Guide in Power BI

Step 1: Ensure Data is Loaded

• Open Power BI Desktop.
• Go to Home > Get Data > Excel Workbook, select your file (e.g., "TransactionData.xlsx"), and load the data.
• In Power Query Editor, ensure columns like T_FROMAPPLI, I_O, and AMOUNT are correctly typed:
  • T_FROMAPPLI and I_O as Text.
  • AMOUNT as Decimal Number.
• Click Close & Apply to load the data into the model (table named, e.g., "Transactions").

Step 2: Create Measures for "SAA I" and "SAA O"

To calculate the metrics, we’ll create measures in Power BI’s Data Analysis Expressions (DAX).

1. Go to the Modeling Tab:

   • Select your table (e.g., "Transactions") in the Fields pane.
   • Right-click > New Measure.

2. Define Measures:

   • SAA I Count (Number of SAA I transactions):

     SAA I Count = CALCULATE(COUNTROWS(Transactions), Transactions[T_FROMAPPLI] = "SAA", Transactions[I_O] = "I")
     

   • SAA I Value (Total value of SAA I transactions):

     SAA I Value = CALCULATE(SUM(Transactions[AMOUNT]), Transactions[T_FROMAPPLI] = "SAA", Transactions[I_O] = "I")
     

   • SAA O Count (Number of SAA O transactions):

     SAA O Count = CALCULATE(COUNTROWS(Transactions), Transactions[T_FROMAPPLI] = "SAA", Transactions[I_O] = "O")
     

   • SAA O Value (Total value of SAA O transactions):

     SAA O Value = CALCULATE(SUM(Transactions[AMOUNT]), Transactions[T_FROMAPPLI] = "SAA", Transactions[I_O] = "O")
     

Step 3: Display the Results

1. Add a Table Visual:

   • On the Report canvas, click the Table icon in the Visualizations pane.
   • Drag the measures (SAA I Count, SAA I Value, SAA O Count, SAA O Value) to the Values area.

2. Format the Table:

   • Click the table, go to Format Visual (paint roller icon):
     • Under Values, increase font size for readability.
     • Add a title like "SAA I and SAA O Metrics" under General > Title.

3. Alternative: Use Card Visuals:

   • Add four Card visuals to the canvas.
   • Assign each measure to a card and label them (e.g., "SAA I Transaction Count", "SAA I Total Value", etc.).

Step 4: Validate with Sample Data

From the sample data provided (23 rows), let’s check:

• SAA I (T_FROMAPPLI = "SAA" and I_O = "I"):
  • No rows match this condition.
  • Result: Count = 0, Value = 0.
• SAA O (T_FROMAPPLI = "SAA" and I_O = "O"):
  • Row 3: T_FROMAPPLI = "SAA", I_O = "O", AMOUNT = 21526.52 (USD).
  • Row 4: T_FROMAPPLI = "SAA", I_O = "O", AMOUNT = 20171.83 (AED).
  • Result: Count = 2, Value = 21526.52 + 20171.83 = 41698.35 (raw sum, despite different currencies).

Output in Power BI: | Metric | Value | |-----------------------|----------| | SAA I Count | 0 | | SAA I Value | 0 | | SAA O Count | 2 | | SAA O Value | 41698.35 |

Step 5: Save Your Work

• Go to File > Save As, name it "SAA_Transactions.pbix", and save it.

Alternative: Using a Matrix Visual

For a different layout:

1. Add a Matrix visual to the canvas.
2. Configure:
   • Rows: Leave blank or add a custom column later if needed.
   • Columns: Drag I_O (shows "I" and "O").
   • Values: Add "Count of T_TYPE" (for transaction count) and "Sum of AMOUNT" (for total value).
3. Filter:
   • In the Filters pane, set T_FROMAPPLI to "SAA" under Filters on this visual.
4. Result:
   • Columns: "I" and "O".
   • "I": Count = 0, Sum = 0.
   • "O": Count = 2, Sum = 41698.35.

Notes

• Sample Data Limitation: In the 23-row sample, there are no "SAA I" transactions (T_FROMAPPLI = "SAA" and I_O = "I"). Your full dataset might have them, and the measures will reflect that.
• Currency Consideration: The total value for "SAA O" (41698.35) sums USD and AED amounts directly, which isn’t ideal without conversion. To fix this:
  • In Power Query, normalize AMOUNT to one currency (e.g., USD) using an exchange rate (e.g., 1 AED = 0.27 USD), then adjust the measures.
  • Example: 21526.52 USD + (20171.83 AED * 0.27) ≈ 26972.91 USD.
• Clarification: If "SAA I" and "SAA O" refer to something else (e.g., SYSTEM_ID containing "SAA"), let me know, and I’ll adjust the filters.

This solution provides a clear, actionable way to see "SAA I" and "SAA O" metrics in Power BI. Let me know if you need further customization!