powerbidistinctpowerbi-desktopdistinct-values
Getting a total of the (filtered) unique articles in a table visualization in PowerBi
I have this table-visualization in PowerBi formed by using data from diverse tables and with several filters. How do I get a total-row which shows the amount of unique articles in this visualization?
In the screenshot there's a piece of this visualization.
According to this screenshot the total-row should come up with "10", because of the 10 unique 'artnr'. Preferably it should change as soon as the filters are set differently.
Solution
msta42a gave a right answer. I used it to solve my question.
UniqueArticle = calculate(distinctcount(Table[artnr]), ALL(Table[artnr]))
- Setting moving default start and end Date in power BI
- Power Query Conditional JOIN - JOIN with WHERE clause
- Power BI: Count the number of times a text appears in each row
- How to sort weekdays in Power BI based on today
- What are the minimum Azure permissions required to publish a Power BI report using "App Owns the Data"?
- Filter multiple visualizations to exclude values that have already been excluded
- How to count direct and indirect test cases for Features, Requirements, and Change Requests in Power BI using DAX?
- Group average as a baseline & individual variance to baseline
- DataFormatError whenever I filter a column
- How to structure input to use PowerBI REST API: multi-value parameters
- Data missing from basic visual in Deneb (vega-lite)
- Microsoft Power BI REST API PowerBINotAuthorizedException
- Filtering values on one visual affects filtering on second visual
- PowerBI Embed in Angular "User Owns Data" | Getting InteractionRequiredAuthError: AADSTS65001 while generating powerbi access token
- Displaying a Fixed Timeline in a Power BI Line and Clustered Column Chart with Slicers
- Integrate PowerBI report using 'embed for customer approach' to angular application which use OKTA to authenticate
- Why do fields still show in PowerBI when I have them filtered in the model?
- How to sort a line chart X-axis by a different column than displayed
- Row Comparison in PowerBI
- PowerBI Slicer showing single value from group of values
- Sorting Months in a Power BI Visual by Fiscal Year and Month
- Power BI report of excel data source
- PowerBI REST API get reports
- Reference another table when getting data from Python in Power BI
- Power BI - Powerpoint Export is Not even Showing
- Is it possible to schedule refresh in Power BI with Windows Task Schedule?
- PowerBi measure where the total is based on the legend and adjusts total for selected slicer
- DAX problem - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value
- How do I create a bar plot histogram of a parameter in power BI
- How to show a colum total in a Power BI matrix visualisation that has implicit columns based on values?