adding measure to the table

[Anonymous]

Hi everyone! 

I experienced the problem with adding measure to the table view in power bi. I have original table with the data filters for the past 3 weeks:

I added the measure calculating difference between some dates and inserting 0 if the data column is null; however, when I add this measure to the table, happens this:

It shows unrelevant values with the wrong dates and etc. 

Help please! 

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[Anonymous]

The table to which I need to add a measure which calculates difference between dates:

I created measure which calculates the difference:  

Мера = IF(ISBLANK(SELECTEDVALUE(TT_INDeliveryData[sscc_disaggregated_ts])), 0, DATEDIFF(SELECTEDVALUE(TT_INDeliveryData[gtin_warehous_ts]), SELECTEDVALUE(TT_INDeliveryData[sscc_disaggregated_ts]),DAY))

And when a add this measure as a column to the table, it shows values not only for those rows which were in the previous screenshot, but also some irrelevant (maybe to the all values in the table from DWH):

[amitchandak]

@Anonymous , Try like

Мера = IF(ISBLANK(SELECTEDVALUE(TT_INDeliveryData[sscc_disaggregated_ts])), blank() , DATEDIFF(SELECTEDVALUE(TT_INDeliveryData[gtin_warehous_ts]), SELECTEDVALUE(TT_INDeliveryData[sscc_disaggregated_ts]),DAY))

[Anonymous]

It is still shows not all values from the original table:

[v-easonf-msft]

Hi, @Anonymous 

Can you post some sample data in table form or pbix file(without sensitive data) and your expected result for further research? Also, if there are related mesure fields in the table visual, please share related formulas.

Best Regards,
Community Support Team _ Eason