Forum Discussion
NUMBER OF VISITS
- 6 years ago
Hi manideep547
it is exactly thread for Desktop https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer or DAX https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands forums, but try the next technique
First, create a calculated table
Table 2 = SUMMARIZE('Table','Table'[DESTINATION],'Table'[DATE],'Table'[ID],"N visits",COUNTROWS('Table'))or you can do the same in the Power Query Editor mode using Group By functionality
Second, creare a measure in your table
Measure = CALCULATE(COUNT('Table 2'[ID]),ALLEXCEPT('Table 2','Table 2'[DESTINATION]))and you will be able to get desired output
Hi manideep547
it is exactly thread for Desktop https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer or DAX https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands forums, but try the next technique
First, create a calculated table
Table 2 =
SUMMARIZE('Table','Table'[DESTINATION],'Table'[DATE],'Table'[ID],"N visits",COUNTROWS('Table'))
or you can do the same in the Power Query Editor mode using Group By functionality
Second, creare a measure in your table
Measure =
CALCULATE(COUNT('Table 2'[ID]),ALLEXCEPT('Table 2','Table 2'[DESTINATION]))
and you will be able to get desired output
- manideep5476 years agoHelper III
az38 can you please attach the .pdix file and Thank you for your reply.
- az386 years agoCommunity Champion