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.
I have a simple query with one column that I want to use to in DAX. I have the column in a slicer to select a value but no mater what I select I always get all the rows in my DAX caculation. to test I'm using the below DAX as a calculated to feed a card
Solved! Go to Solution.
Basicly DAX can't work with test fields like that. It can with numbers but not with text. For instance if you build a table like
Column1 | Column2 |
A | 1 |
B | 10 |
C | 100 |
then a formula like
Basicly DAX can't work with test fields like that. It can with numbers but not with text. For instance if you build a table like
Column1 | Column2 |
A | 1 |
B | 10 |
C | 100 |
then a formula like
below is some sample data. the slicers would be on the 1st 2 tables and I want them to filter the 3rd. from the 3rd table I would take the 'order transfer' data and filter the data on the final result table
Scheduled_Ship_date |
20.03.13 |
20.03.14 |
20.03.15 |
in_whs_key |
014 |
050 |
122 |
128 |
144 |
146 |
148 |
order transfer | in_whs_key | Scheduled_Ship_date |
1450601 | 14 | 20.03.14 |
1450601 | 50 | 20.03.13 |
1450621 | 144 | 20.03.13 |
1455901 | 128 | 20.03.13 |
1455901 | 146 | 20.03.15 |
1456591 | 122 | 20.03.13 |
1456591 | 148 | 20.03.13 |
1456593 | 128 | 20.03.13 |
1456595 | 146 | 20.03.15 |
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |