Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Microsoft Team,
I am getting an error as follows
"Cannot Convert value 'Australia' of type text to type True/false.
The measure is as follows:
Solved! Go to Solution.
Hi @Anonymous ,
Suppose you need to retrieve the following table using those filters.
If the table has created relationships with other tables, then you can filter directly.
If there is no relationship between theses tables, please create the following measure.
Measure =
CALCULATE (
[SP],
FILTER (
'Table 2',
'Table 2'[Date] IN ALLSELECTED ( 'Date'[Date] )
&& 'Table 2'[item] = SELECTEDVALUE ( 'Item'[itemName] )
&& 'Table 2'[Product] = SELECTEDVALUE ( 'Product'[ProductName] )
&& 'Table 2'[RU] = SELECTEDVALUE ( Store[RUName] )
)
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Suppose you need to retrieve the following table using those filters.
If the table has created relationships with other tables, then you can filter directly.
If there is no relationship between theses tables, please create the following measure.
Measure =
CALCULATE (
[SP],
FILTER (
'Table 2',
'Table 2'[Date] IN ALLSELECTED ( 'Date'[Date] )
&& 'Table 2'[item] = SELECTEDVALUE ( 'Item'[itemName] )
&& 'Table 2'[Product] = SELECTEDVALUE ( 'Product'[ProductName] )
&& 'Table 2'[RU] = SELECTEDVALUE ( Store[RUName] )
)
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Try this:
Hi Truptis,
After trying the below code also,
Comparable Left = var selection = Selectedvalue(Store[RUName])
I was getting this error ""Cannot Convert value 'Australia' of type text to type True/false."
Any other logic please?
Hi @Anonymous
you need to complete this filter condition here
something like FILTER('Store',Store[RUName] = "Australia") etc. or whatever filter condition you want to put here.
Regards,
Aditya
Hi Aditya,
It should pick dynamically like = Selectedvalue(Store[RUName])
When I am giving as above it was throwing same error like conversion issue
Hi Aditya,
I have few tables - Date, Store, Item , product tables
From Date Table - Date(YEAR), Date(Month)
From Store Table - Store(RUName)
From Item Table - Item(itemName)
From Product Table - Product(ProductName)
And Now I have one Measure ie., [SP]
I am trying to retrieve the [SP] data with all above filter values
Can I get some logic , how I can pass all those filters in DAX
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
49 | |
45 | |
20 | |
16 |