Forum Discussion

jonpoole's avatar
jonpoole
Frequent Visitor
8 years ago
Solved

Calculate repeat values from within user defined periods

I have a  table which looks like   ClientID Date Repeats 1 01/04/2018 3 2 02/04/2018 1 3 03/04/2018 1 4 04/04/2018 2 1 04/07/2017 3 6 05/07/2017 1 7 06/07/2017 2 7 07/07/2017 2 5 06/06/2017 1 1 07/...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi bathnesresearch,

     

    "in essence, create a dynamic axis a using the measure filtered by the slicer."

     

    <--- So your requirement is to create a dynamic calculate column based on which is your slicer, right? I'm afraid you can't achieve this because power bi doesn't support dynamic calculate column.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi jonpoole,

 

You can create a measure using DAX as below:

RepeatCount =
CALCULATE (
    COUNTROWS ( Table1 ),
    ALLEXCEPT ( Table1, Table1[ClientID] ),
    ALLSELECTED ( Table1[Date] )
)

 

 

In addtion, based on my test, I'm afraid the priority of a slicer is very low so that we can't filter context based on a slicer but only use a slicer to filter other row context.

 

Regards,

Jimmy Tao

bathnesresearch's avatar
bathnesresearch
Regular Visitor
8 years ago

Thanks Jimmy, we got a very similar output, that's helpful.


The other requirement (neglected this in my OP) is for a summary graph of the instances (a count of duplicate counts) which is dynamic relative to the aforementioned date range (in essence, create a dynamic axis a using the measure filtered by the slicer).

 

My understanding from your post and some further search is that the slicer priority wouldn't allow this to happen, but I thought I'd double check.

 

thanks again!

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi bathnesresearch,

     

    "in essence, create a dynamic axis a using the measure filtered by the slicer."

     

    <--- So your requirement is to create a dynamic calculate column based on which is your slicer, right? I'm afraid you can't achieve this because power bi doesn't support dynamic calculate column.

     

    Regards,

    Jimmy Tao