Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
5 years ago

Help with simple measure

I have data that shows Card Reads. I need to calculate the following and be able to use "State" as the legend

 

% = ([Unique card reads] / [Unique card reads in Jan. 2020]) * 100%

 

Basically divide every month's card reads by that value in Jan 2020, broken down by State. I tried hardcoding it and it still doesn't work but I"d like to not have it hard coded and have it in a measure.

Need Help

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey bhmiller89 ,

     

    can you show us the formula of the 2 measures you are using?

     

    Best regards

    Denis

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi bhmiller89 ,

    = CALCULATE([Unique card reads] / [Unique card reads in Jan. 2020]) * 100%), ALLEXCEPT(table, table[state]))

     

    Thanks

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    bhmiller89 

    Try :
    Hope you have a DATES table connect to the fact table:

    % = 
DIVIDE(
    [Unique card reads],
    CALCULATE(
         [Unique card reads],
         Date[Year] = 2020,
         Date[Month] = 1,
    )
)





  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi bhmiller89,

    Did Fowmy 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestion to help others who faced similar requirements to find it more quickly.

    If these also not help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng