Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
HI @barlevitzky,
I can't down sample file from that site, can you please upload it to onedrive or google drive?
Regards,
Xiaoxin Sheng
Hi, @v-shex-msft
Here is the link:
https://drive.google.com/open?id=10YGqLNId7nViwWsbfLrpnuncDSE4uHC1
Thanks
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
Hi,
Sorry,
Please try this one:
https://drive.google.com/file/d/10YGqLNId7nViwWsbfLrpnuncDSE4uHC1/view?usp=sharing
Thanks
HI @barlevitzky,
Hmm, it seems like your sharing link still not work:
Reference links:
Regards,
Xiaoxin Sheng
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |