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 div...
Need Help
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,
    )
)