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,
I'm trying to create a column which will display an outcome depending on the results of the duplicate detection
This is sample data that I'm working with
This is the outcome I want.
The first thing I look at is if Address, Status and Company are all the same. After looking at that we will then look at the Agent, if there is multiple Agents for the same Address then we will display "Half". If there is one or more Address that have the same Agent then we will display "Full"
This is the outcome I got from Power BI. I did a simple Concatenate for the Conc column the merge the columns and then used this DAX formula to return the "Half" or "Full"
Half/Full Appointment =
Var Appoint = 'Table'[Conc]
var AppCount =
CALCULATE(
COUNTROWS('Table'),
all('Table'),
'Table'[Conc] = Appoint
)
return
IF(AppCount <= 1, "Full", "Half")
Does anyone know how to get the outcome that I'm looking for?
PBI File: https://www.dropbox.com/s/40kthwjmdwufm7l/Appoint.pbix?dl=0
Cheers,
Mike
Solved! Go to Solution.
Please try this column expression to get your result.
HalfFull =
VAR agentcount =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Agent] ),
ALLEXCEPT ( 'Table', 'Table'[Address], 'Table'[Status], 'Table'[Company] )
)
RETURN
IF ( agentcount = 1, "Full", "Half" )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this column expression to get your result.
HalfFull =
VAR agentcount =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Agent] ),
ALLEXCEPT ( 'Table', 'Table'[Address], 'Table'[Status], 'Table'[Company] )
)
RETURN
IF ( agentcount = 1, "Full", "Half" )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you, Pat!
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |