Forum Discussion
Discrepancy in Measure Results Between Different Visualization Types
hey,
i did found where the problem was ,
power bi did create from alone a relation between my tables , what caused the misscount
good day !
Thank you for your description. Would you please add your work-in-progress Power BI Desktop file so that members of the forum may better appreciate the state.
hello,
sorry but i did'nt understand what you ask for ?
the data i'm working with ?
let say :
i have
col1 col2 col3 col4 location (as col 5)
value1.1 value2.1 value3.1 value4.1 Mongolia|United States
value1.2 value2.2 value3.2 value4.2 Mongolia
value1.3 value2.3 value3.3 value4.3 Mongolia|Germany
value1.4 value2.4 value3.4 value4.4 Mongolia|France
through my dax measure i want to calculate the occurencies for each country for exemple ,
i did extract all unique country from this col to list, that i convert into a sigle table col
then i check if a country in the list is in the location(as col 5)
country list table
country (col)
Mongolia
United States
Germany
France
United Kingdom
...
but my measure count only line where the country = to the country in location (it seems like it use "=" and not "in" operator) even with "containsstring"
it will count me
Mongolia -> 1 , but the country is repeated 4 times
i do use the same function for other cols , with the same process, and it works fine , but here not !!!
if you have any idea
thanks