Multiple 2 columns didn't get expected results! Please help :)

Sunshine_2024 — Tue, 19 Mar 2024 23:38:57 GMT

Hello everyone,

I am trying to replicate a table from SQL to Power BI by creating some measures & columns, but when I multiplied them, the resulting column would always produce the wrong values. I really need some help please.

My master table looks like this (each row is a unique record):

In SQL, I used some query to slice and dice the master table, and it produced the correct results as below:

The 4th column "MULTI_SEAT_PER_FLIGHT_BY_MONTH" is the same (=14) for each month but it's 12 for Apirl only.

However, I just couldn't get the last column right in Power BI, no matter how I manipulate it. The current wrong table looks like this:

The columns and measures are created as follows:

- MULTI_SEAT_COUNT (measure):

MULTI_SEAT_COUNT = COUNTROWS('MULTI SEAT MASTER VIEW')

- FLIGHT_COUNT_MEASURE (tried both measure and column) - each count is a unique concatenation of the following 5 columns:

FLIGHT_COUNT = COUNTROWS(SUMMARIZE('master_table', 'master_table'[OPERATING_CODE], 'master_table'[FLIGHT_NUMBER], 'master_table'[ARRIVAL], 'master_table'[DEPARTURE], 'master_table'[FLIGHT_DEPARTURE_DATE]))

- OPERATED_MULTI_SEAT_PER_FLIGHT (column):

OPERATED_MULTI_SEAT_PER_FLIGHT = SWITCH (

TRUE,

'master_table'[FLIGHT_DEP_YEAR_MON] = "04/2024", 12,

14 )

- OPERATED_MULTI_SEAT (column):

OPERATED_MULTI_SEAT = 'master_table'[FLIGHT_COUNT_MEASURE] * 'master_table'[OPERATED_MULTI_SEAT_PER_FLIGHT]

Any idea what is the issue please? Appreciate your help in advance. Thank you!

Re: Multiple 2 columns didn't get expected results! Please help :)

lbendlin — Sat, 23 Mar 2024 17:55:03 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Re: Multiple 2 columns didn't get expected results! Please help :) in DAX Commands and Tips

Multiple 2 columns didn't get expected results! Please help :)

Re: Multiple 2 columns didn't get expected results! Please help :)