Forum Discussion
False-positives in dataset
Hi all,
I'm comparing 2 values from two different tables. My data tables comes from two different IT systems reporting in to each their website.
I'm interested in seeing values that are not present in both tables, which I have succeeded with. It returns about 10-20 values with values that are not present in both IT system. After investigating, these values are present in both systems in some sense, but are just not updated on the IT system yet.
Is there a way for me, in Power BI, to mark these values as "false positives"? And more importantly, what happens next time I refresh my dataset?
Hi emilKDIT ,
To my knowledge, since the values which not present in both tables are returned by DAX, they would be changed after the data refreshed. -->Power BI is a "read only" system so it doesn't have the ability to store data beyond a refresh.
Refer to:
https://community.powerbi.com/t5/Power-Query/Maintain-historical-Data/td-p/1135774
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
emilKDIT , intersect
https://docs.microsoft.com/en-us/dax/intersect-function-dax
for Measure way you need a common table say for website
M1= Countrows(Table1)
M2=Countrows(Table1)
false true =
Countx(filter(values(Web[Website]) , not(isblank([M1])) && isblank([M2])), [Website])
Hi emilKDIT ,
To my knowledge, since the values which not present in both tables are returned by DAX, they would be changed after the data refreshed. -->Power BI is a "read only" system so it doesn't have the ability to store data beyond a refresh.
Refer to:
https://community.powerbi.com/t5/Power-Query/Maintain-historical-Data/td-p/1135774
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi emilKDIT ,
Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you
Best Regards,
Eyelyn Qin
