Forum Discussion

Atifz's avatar
Atifz
Frequent Visitor
6 years ago

Reverse Cumulative measure

Hi all,   I am trying to create a reverse cumulative measure and I am having difficulty when there are blanks in my data.    Using this calculated measure, I get the table below, but where there ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try using CountA([BidderID]) or [Registrations], in place of Registrations[Registrations]

Atifz's avatar
Atifz
Frequent Visitor
6 years ago

hi amitchandak 

 

It doesn't let me put the CountA in the Sum, but if I replace the whole row with it, I get the same results as the beginning, with the rows with blank showing 460

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Share sample of data in your original data format

    • Atifz's avatar
      Atifz
      Frequent Visitor
      6 years ago

      hi amitchandak ,

       

      My data model is from analysis services. How would I be able to share sample data?

      • v-frfei-msft's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Atifz ,

         

        Export to excel removing any Confidential Information and share your DAX formuals here. Please upload your files to One Drive and share the link here.