How to Find UNIQUE (Distinct) Values in Power BI
Learn How to Find UNIQUE (Distinct) values in Power BI. In Power BI, we can find unique or distinct values and get UNIQUE (Distinct) values from column then show only unique (Distinct) values. We can handle UNIQUES with DAX Functions in Power BI. You will get more 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 : • MS Excel Tutorial
Excel VBA Macro : • Playlist
Power BI : • 🚀 PowerBI Tutorial for Beginners 😎
Power BI DAX Tutorial : • Power BI DAX Tutorial
========================================================================
For more awesome Power BI Tutorial videos like this. Visit our official YouTube channel.
***************************** - "Pettaka Technologies" - *********************************
========================================================================
Connect with us:
Subscribe | / pettakatechnologies
Facebook | / pettakatechnologies
LinkedIn | / pettaka-technologies
Twitter | / pettakatech
********************************** - "Happy Learning" - **********************************