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
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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

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

    Anonymous althought Ashish_Mathur proposed calcualted columns, I would recommend to use measures for performance, but it all depends how big your dataset is.


    Calculated column is the last thing you want to do. Cheers!!