Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Please elaborate some more and if possible share some demo data alongwith the desired output.
Thanks!!
Hi,
I am not sure how your datamodel looks like, but please try something like below.
expected result measure: =
RANKX (
SUMMARIZE (
ALLSELECTED ( PRODUCT_FACT_table ),
PRODUCT_DIM[SAP_MATERIAL],
PRODUCT_ATTRIBUTES_DIM[SAP_MATERIAL_DESCRIPTION]
),
[units prof]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @WaldoM
please try
=
RANKX (
SUMMARIZE (
CALCULATETABLE ( FactTable, ALLSELECTED () ),
PRODUCT_DIM[SAP_MATERIAL],
PRODUCT_ATTRIBUTES_DIM[SAP_MATERIAL_DESCRIPTION]
),
[units prof]
)
User | Count |
---|---|
57 | |
21 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |