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 table as below called (Results) which has 4 columns [Name], [Age], [Country],[Position]
[Client] [Sites] [Country] [Position]
Parker 2 UK 1
Peters 2 UK 1
Allens 1 UK 2
Farmer 6 Wales 2
Parker 1 Wales 3
Parker 4 France 3
Allens 5 France 101
Peters 3 France 105
Allens 1 France 108
I would like to introduce a DAX Measure or a Calculated Column to create another column [Healthy] as the table below
This new column in based on the following criteria taken from the [Position] column
(Results)[Position]<=2 or >=100 (less than or equal to 2 or greater than or equal to 100)
[Client] [Sites] [Country] [Position] [Healthy]
Parker 2 UK 1 True
Peters 2 UK 1 True
Allens 1 UK 2 True
Farmer 6 Wales 2 True
Parker 1 Wales 3 False
Parker 4 France 3 False
Allens 5 France 18 False
Peters 3 France 105 True
Allens 1 France 108 True
What would be the simplest way to calculate this?
Thanks for your time.
Solved! Go to Solution.
What is the result you want? If my understanding is incorrect, please correct me.
Your expectation result should be :
After summarize column [Client], [Sites], [Country] ,
if sum ( [Position] ) <= 2 and sum[position]>=100 then Ture else False
or : if avg ( [Position] ) <= 2 and avg [position]>=100 then Ture else False
Which kind of aggregation is what you want ?
calculated column and if statement.
= if(table[position] <= 2 || table[position]>=100, true(),false())
Sorry columns are [Client], [Sites], [Country],[Position]
What is the result you want? If my understanding is incorrect, please correct me.
Your expectation result should be :
After summarize column [Client], [Sites], [Country] ,
if sum ( [Position] ) <= 2 and sum[position]>=100 then Ture else False
or : if avg ( [Position] ) <= 2 and avg [position]>=100 then Ture else False
Which kind of aggregation is what you want ?
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 | |
20 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |