Forum Discussion
Solved
Same measure
[Using a direct query] Hi, I have the following table with the following measure: Total Moves = COUNT(rfid_location_history[timestamp]) However when I test on a table I ...
Solved, established a relationship between Date in the Rolling Calendar table and timestamp in the Moves table.
The example I was referencing was
Where the revenue was
Total Revenue =
SUMX(
'Sales Data',
'Sales Data'[OrderQuantity]
*
RELATED(
'Product Lookup'[ProductPrice]
)
)
and the month element was
If I switched to COUNTX would that give the the monthly grouping of moves or do I need to build a query to get this?