Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all ,
I have the following measure where i am creating a calculated measure based on certain criteria as below.
Now i want the sum of my t_measure as my output so i can show overall number in a card.
I tried Sumx but it doesnt work as expected. can someone help here.
Hi!
Can you share some data and what your expected result is? Sounds like a SUMX() should work but if it doesn't it must be something I'm missing.
hi @TomasAndersson So basically i have below data where the measures are calulated.
t_measure = bod* weight / freq
so i want sum of T _ measure which should be (7.47+2.65+2.30+......8.87)=55.63%
If i use sumx as below i see following result. can u please help here.
I see! Try doing the same measure but as a SUMX() from the beginning instead, sort of like:
SUMX T_ measure =
SUMX(Table,
DIVIDE(Table[Bod] * Table[Weight],Table[freq])
)
You'd have to adjust above according to your table/column names.
Then you get the total as expected:
Hope this helps!
There are the calculations of my measures.
Based on below measures , can u please tell me how to proceed, as i still dont get desired result. Thanks in advance.
BOD=averagex(values(Mapping_dim[Test_Level1]),AVERAGEX(VALUES('mapping_dim'[Level2]), AVERAGEX(VALUES('mapping_dim'[Level3]),AVERAGEX(VALUES('mapping_dim'[Level4]), AVERAGEX(VALUES('mapping_dim'[Level5,6]),
Thanks,
Binay
@binayjethwa , You can try like
using common dim
sumx(Mapping_dim, [t_measure])
or some column
sumx(dim1[Col1], [t_measure])
Hi @amitchandak ,
This is the data what i am having . so basically
t_measure = bod* weight / freq
so i want sum of T _ measure which should be (7.47+2.65+2.30+......8.87)=55.63%
If i use sumx as below i see following result.
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |