Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Summing a measure

Hi,   I have a dataset on a list of assets which will need to be replaced as time goes on. Each has a different lifecycle so they will expire at different times. The table below is a sample and con...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous

 

You may have a look at this post.It's better that if you could share your sample data which could reproduce your scenario and your desired output.You can also upload the pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks v-cherch-msft! I have had a look at the post and tried to implement however I am still having trouble. I have uploaded a sample dataset here with the measures I currently have. 

 

Thanks again for your help!

 

 

 

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Anonymous

     

    even though you've many assets you should be getting a great compression on the dataset. besides when the DAX gets simpler it also gets faster for your users to do clicky clicky draggy droppy at a reasonable speed. It is something you can test if your report's slow