Forum Discussion

DSPVarma's avatar
DSPVarma
Frequent Visitor
2 years ago
Solved

Getting blank value when dividing two measures in the matrix visual

Hi All, Please help me on the following; I have 2 measures: The first measure name is ‘Total Difference in minutes’ which is calculated by taking out the difference between the End date and the s...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi DSPVarma 

     

    Thanks for the reply from TomMartens , please allow me to provide another insight:

    Copy the Slicer from Page FundOpt and Paste in page Fund workings:

    Then select Sync:

    View > Sync slicers:

    Select the slicers and hide them in Page Fund workings:

    The result is as follow:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DSPVarma's avatar
DSPVarma
Frequent Visitor
2 years ago

I tried all the methods but was unable to tackle this one. Can somebody help me out with this one?

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DSPVarma 

 

Thanks for the reply from TomMartens , please allow me to provide another insight:

Copy the Slicer from Page FundOpt and Paste in page Fund workings:

Then select Sync:

View > Sync slicers:

Select the slicers and hide them in Page Fund workings:

The result is as follow:

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DSPVarma's avatar
    DSPVarma
    Frequent Visitor
    2 years ago

    Anonymous Thank you very much. It worked for me with your solution.
    TomMartens Thanks a lot

     

  • DSPVarma's avatar
    DSPVarma
    Frequent Visitor
    2 years ago

    Anonymous Can you please help me with a measure to get the cumulative total for the "Projected fund required" column after sorting the "Sum of Net Contribution" column from highest to lowest. Many thanks for considering my request.