Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
You have to convert the output of the non-blank to text as well in order for it to display "N/A" on the blanks.
Column = IF ( ISBLANK ( 'Table'[Sales] ), "N/A", TRIM ( 'Table'[Sales] ) )
Hi @NISH72 ,
If you connect to SSAS using connect live mode in Power BI Desktop, then you can only create report level measures instead of calculated columns. So you may create measure like DAX below, and display it in table visual.
Measure1= IF(MAX(Table1[City])=BLANK(),"n/a", MAX(Table1[City]))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @NISH72 ,
Try this. Use = BLANK()
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Proud to be a Super User!
You have to convert the output of the non-blank to text as well in order for it to display "N/A" on the blanks.
Column = IF ( ISBLANK ( 'Table'[Sales] ), "N/A", TRIM ( 'Table'[Sales] ) )
Hi @NISH72 ,
Best to go to Power Query, Add Column, Conditional Column. In your case Value and Column1 will be the same column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @NISH72 ,
If (table[columnname] = "","N/a",table[columnname])
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @NISH72 ,
Try using null instead of "" for that column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
If (ISBLANK(table[columnname]) ,"N/a",table[columnname])
Hi @NISH72 , or this.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @NISH72 ,you may need to check your data type for that column.
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |