Forum Discussion

troystyle's avatar
troystyle
Regular Visitor
10 years ago

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...
troystyle's avatar
troystyle
Regular Visitor
10 years ago

SeanSadly it is not working or what i seek.

The solution must be able to work on a Status ID/Program relationship i.e The count of Status ID studying politics in each quarter. the relationship is tied to Status ID/Program and first term. it must recognise the first term for it to work effectively.

 

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

troystyle This shows count of Status ID studying politcis in each quarter?

Do you need DISTINCT count?

  • troystyle's avatar
    troystyle
    Regular Visitor
    10 years ago

    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