The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
New to Power BI, I couldn't find out how to put the column "Churn Label" into the IF Command, so I went to the solutions (Of the exercise I was doing for DataCamp) to find out. It turns out, I knew how to do it but the way I was typing it in was not working.
Anyways, I tried to type it in as "Churneb" in the solutions file, and the same exact DAX command did not work. Is there something I am missing?
Thanks in advance!
Solved! Go to Solution.
You are creating a measure. You can use the same formula to create a calculated column. Otherwise, you need to wrap the column with SELECTEDVALUE:
IF ( SELECTEDVALUE ( 'Table'[Column] ) = "ABC", 1, 0 )
You are creating a measure. You can use the same formula to create a calculated column. Otherwise, you need to wrap the column with SELECTEDVALUE:
IF ( SELECTEDVALUE ( 'Table'[Column] ) = "ABC", 1, 0 )
User | Count |
---|---|
14 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |