Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column to count records less than value in same column

Hello All,    I am struggling with something I thought was going to be simple enough, but hours later I need help!   I have the following dataset:   Record SE M R Y Percentile Rank Nor...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks so much parry2k and Ashish_Mathur , I am sooo very grateful for this.

Amazing and super quick!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You are welcome.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Ashish_Mathur 

      I have inputted the calculated columns into my dataset and it is computing correctly across the entire huge dataset, however, I need to be able to filter it by time period and its not doing that automatically with a slicer.  

       

      Download PBX File (same one as previous but with time period added) from here:  Normalised_2 , is there a way to wrap another variable or if statement around this - what I have tried hasnt worked 😞

       

      Thanks so much

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks again, 

        Working really now. The solution to filter by time was ... just another filter 🙂

        M =
        CALCULATE(COUNTROWS(Data2),
        FILTER(Data2,Data2[SE]<EARLIER(Data2[SE])),
        FILTER(Data2,Data2[Time Period]=EARLIER(Data2[Time Period])))
         
        Thanks again for saving the day 🙂