different result

2 Topics

Summarize 2 different tables with filters and returning null for empty results
Hi, How is it possible to summarize together 2 different tables, excluding some values based on the results of a column? For the following scenario: I have a Table1 with unique IDs: table1 ID 1 2 3 4 5 6 There is also this Table2 with some IDs from Table1: table2 ID reason 1 conclude 1 steady 1 not okay 2 steady 2 conclude 3 conclude 6 away I would like to combine both tables into a Table3, where I have all ID's from Table1, and all the reasons from Table2, excluding the reason "conclude", also, when there is no reason for the IDs, the result will be "null": note: for ID 3, there is only "conclude", so the result would be null, because I need to exclude when the reason is "conclude" table3 ID reason 1 steady 1 not okay 2 steady 3 null 4 null 5 null 6 away I have thousands of reasons, so it would be easier to have a filter that excludes only when the reason is <> "conclude". Thx!
Solved
Anonymous
2 years ago Place DAX Commands and Tips
778Views
0likes
3Comments
Different result between Power BI desktop and report server
Hi, Power BI Desktop shows the correct result of a measure (in Hebrew, so no use of pasting) , though when on Report Server, the result is incorrect. On desktop: On server: When I have unchecked the 'persistent filters' like below, the result was corect, till the next refresh, that the same problem appeared again. No filters, same data, very odd... Thanx for any reference.
EmikaTLV
4 years ago Place Report Server
525Views
0likes
1Comment