Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |