Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bhmiller89
Helper V
Helper V

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.

4 REPLIES 4
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Fowmy
Super User
Super User

@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,
    )
)





Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Hi @bhmiller89 ,

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

 

Thanks

selimovd
Super User
Super User

Hey @bhmiller89 ,

 

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

 

Best regards

Denis

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.