Forum Discussion

Jeyeline's avatar
Jeyeline
Icon for Helper III rankHelper III
1 year ago
Solved

Challenge is setting up a datamodel

Dear Team,     We are working with a datamodel integrated with Microsoft Azure Devops and Our Data model consists of workitem fields. Example, Bug, Task, etc. So each work item will have fields suc...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Jeyeline 

     

    I created a sample file. Below is a screenshot. You can download my sample file to see details. Hope it would be helpful.

    The active relationships are on Created Date and Created By columns. The other relationships are inactive. Then use measures to calculate the Count values and use USERELATIONSHIP function to activate the inactive relationships. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Jeyeline's avatar
Jeyeline
Icon for Helper III rankHelper III
1 year ago

Hello danextian , rit_ty7 

 

The source is a single datamodel from azure board source. Sharing the sample Data Record here:

 




  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    You only need a single calendar table. Establish an active relationship for one of the date columns and set the others as inactive. Use the USERELATIONSHIP function in a measure to activate the inactive relationships when needed. In the screenshot below, the relationships shown with broken lines are inactive.

    Inactive relationships cannot be utilized unless USERELATIONSHIP is explicitly used in a measure, meaning they cannot directly filter rows on their own.

     

    Attached is a sample pbix.