Forum Discussion
Solved
Creating bar chart total visits with dynamic distinct count
Hello all, a task that seems simple at first sight gets more complicated with every hour I spend trying, reading and thinking about it. If there is already a post about this, I didn't notice it be...
Customers Count : =
VAR _currentvisitcount =
MAX ( 'Visit Count'[Visit Count] )
VAR _customersvisitcount =
FILTER (
ADDCOLUMNS (
SUMMARIZE ( Data, Customers[Customer_ID] ),
"@visitcount", CALCULATE ( COUNTROWS ( Data ) )
),
[@visitcount] = _currentvisitcount
)
RETURN
COUNTROWS ( _customersvisitcount )
Thank you JiHwan Kim for your quick reply.
To understand it correctly, I have to create a new table with the unique ID's before I can start with the visualization. There is no other solution?
Hi,
Thank you for your feedback.
I created the dimension table for CustomerID because
- I do not know how your actual data model looks like.
- in order to make data model a bit more easy to understand.
No need to create this dimension table.