Help in measure calculation

[barlevitzky]

Hi All,

I need help in creating the following measure:

I have different ID's (361,367) and each ID has different groups. 

The first group is always starting with 1. 

I want to divide each group by the first group. 

so for example in id 361, the measure  will calculate  0.21/0.25 and the result will be 0.84

Thanks in advance

[Anonymous]

Hi @barlevitzky,

Please share some sample data or pbix file to test and coding formula, it is hard to coding formula from a summarize matrix snapshot.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[barlevitzky]

Hi,

Please find attached a sample pbix file.

https://we.tl/t-maRFY4LXiQ

Thanks in advance.

[Anonymous]

HI @barlevitzky,

I can't down sample file from that site, can you please upload it to onedrive or google drive?

Regards,

Xiaoxin Sheng

[barlevitzky]

Hi, @Anonymous

Here is the link:

https://drive.google.com/open?id=10YGqLNId7nViwWsbfLrpnuncDSE4uHC1

Thanks

[Anonymous]

Hi @barlevitzky,

I can't download file for google drive, it alert me not has permission. Did you turn on the share option?

Regards,

Xiaoxin Sheng

[barlevitzky]

Hi,

@Anonymous 

Sorry,

Please try this one:

https://drive.google.com/file/d/10YGqLNId7nViwWsbfLrpnuncDSE4uHC1/view?usp=sharing

Thanks

[Anonymous]

HI @barlevitzky,

Hmm, it seems like your sharing link still not work:

 

Reference links:

Share folders in Google Drive

Regards,

Xiaoxin Sheng