Forum Discussion
LOOKS Dax Measures Calculation HELP!
Hello All, Help needed in resolving this dax measures calculation with regards to a report i am working on. f ind below a sample dataset. The goal is to create two measures or columns. Further deta...
Sean
Community Champion
Community Championtroystyle This shows count of Status ID studying politcis in each quarter?
Do you need DISTINCT count?
Sean The solution is close but not quite.
This is a sample created in excel out of a larger dataset of what i want to achieve. it must allow for filtering
The result must show the actual count and the retention rate, this might require more than one dax measure to achieve as shown.
Thus status ID of Politics in 10/FA but changed to Arts in 11/FA, 12/FA, 13/FA will be counted as part of 10/FA Politics due to the fact that the status id registered as politics in its first year i.e 10/FA.
It seems convoluted but its the nature of my project and really do appreciate your help