How to Find UNIQUE Values in Power BI
- 2023.01.25
- PowerBI

Learn How to Find UNIQUE values in Power BI. With Power BI, we can find unique values in a column using DAX functions. We can handle UNIQUES with Power BI DAX Functions in Power BI Measure and create Table in Power BI for Data Visualization. You will get more awesome videos like this in Power BI DAX Functions Tutorial Series @PettakaTechnologies
=============================================================
#tutorial #powerbi #PettakaTechnologies #daxfunctions #businessintelligence
=============================================================
Steps To Follow:
1) Data source should contain UNIQUE values.
2) Select “New Measure” to add a new measure in Power BI.
3) “New Measure” Formula bar appears.
4) Rename your new “Measure”.
5) Enter Power BI DAX Function “IF” with condition “COUNTROWS is 0”.
6) Select column from the source table.
7) Create a “Table” visual in Power BI Desktop.
8) Use “Conditional Formatting” to highlight the unique values from table.
9) Select “New Table” to add a calculated table in Power BI model.
10) Use “FILTER” DAX Function to filter the unique values in Power BI.
11) Find UNIQUE values and highlight unique values in Power BI Table.
=============================================================
– Learn Business Intelligence with Microsoft Power BI from Pettaka Technologies.
– Power BI Tutorial for Beginners 2023.
– Power BI by Pettaka Technologies.
– Data Visualization with Microsoft Power BI.
=============================================================
This Power BI Find Unique Values Tutorial video covers below topics:
1) How to find unique values in Power BI Desktop?
2) How to count unique values in Power BI?
3) How to get unique values from column in Power BI?
4) How to highlight entire row in Power BI Table?
5) How to filter unique values with DAX in Power BI Desktop?
6) How to deal with a “(UNIQUE)” value in a table visualization?
=============================================================
Playlists:
Microsoft Excel : https://www.youtube.com/playlist?list=PLJH3IJAeLguJ6x8KCp87SdQX5wSYmpr4O
Excel VBA Macro : https://www.youtube.com/playlist?list=PLJH3IJAeLguLVWWBGj7VN2vcl0iZ56drM
Power BI : https://www.youtube.com/playlist?list=PLJH3IJAeLguK_JyNcD6_bpPuR9bJqtBu0
Power BI DAX Tutorial : https://www.youtube.com/playlist?list=PLJH3IJAeLguI_5fCCSPFwUAyMq7e8WzTd
========================================================================
For more awesome Power BI Tutorial videos like this. Visit our official YouTube channel.
****************************** – “Pettaka Technologies” – **********************************
========================================================================
Connect with us:
Subscribe | https://www.youtube.com/c/PettakaTechnologies
Facebook | https://www.facebook.com/PettakaTechnologies
LinkedIn | https://www.linkedin.com/company/pettaka-technologies
Twitter | https://twitter.com/PettakaTech
*********************************** – “Happy Learning” – ***********************************