Table Values Incorrect When I Add a Measure

[RyanLeeMc]

Hello, 

I'm having an issue with a table visual....it contains a single account number from an accounts table and then info of all the bookings linked to that account number from a booking table (see below)

For some reason when I add in a measure to this table, all the other records from the bookings table now appear with empty values, even though they are not linked to the account number (see below)

Please help 🙂

[Anonymous]

Hi @RyanLeeMc,

It seems like the newly added measure expands the records and breaks the row context that the previous formulas required so they do not show the corresponding calculation results. You can try to add a filter to check if the current formula results are not equal to zero to skip the calculation on the wrong ranges.

ISFILTERED function (DAX) - DAX | Microsoft Docs

In addition, can you please share the Dax expression and some dummy data that keep the raw data structure? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[darshaningale]

there should me one-many cardinality from the accounts to bookings table.

[Nahid_3152]

HI @RyanLeeMc ,
Hope u r doing well.

What kind of cardinality ur using? what is ur measure syntax? If ur cardinality many to many then u may face some problems. 
For using Column 
Day_eclipse= DATEDIFF (1st date,2nd Date,DAY)

[RyanLeeMc]

Hi, 

The relationship between the bookings table and accounts table is many to one, no dupes in accounts table. 

This is the measure I am adding to the table that seems to mess with all the values:

Days Elapsed = DATEDIFF(FIRSTDATE(bookings[start_date]),LASTDATE('date table'[Date]),DAY)

I'm doing it this way so I can find the days between the start date and the current date selected (on a slicer)

Thanks

[darshaningale]

The DaysElapsed measure should be 

Days Elapsed = DATEDIFF(FIRSTDATE(bookings[start_date]),SELECTEDVALUE('date table'[Date]),DAY)

[RyanLeeMc]

Hi, 

I tried your solution but it returns no values for the measure, I have the slicer as follows:

I need to use LASTDATE so that it picks up the last date selected in the date range (31/01/2019).

I've had another play around and it I have removed the account_id from the table and instead used the account_id from the bookings tables and it seems to work fine, so must be something to do with the relationships? 

[darshaningale]

Hi @RyanLeeMc If you can provide a pbix file with sample data then probably can help.