Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Members,
Could you please kindly help to solve the following problem? see the picture
i would like that the sum celds are igual to subtotal of the matrix.
Best regards
Solved! Go to Solution.
Hi @ChiRomeu
please try
Count =
SUMX (
CROSSJOIN (
SUMMARIZE ( Coutry, Country[Continent], Country[City] ),
VALUES ( Company[Company] ),
VALUES ( Products[Product] ),
VALUES ( Services[Service Type] )
),
COUNTROWS ( CALCULATETABLE ( VALUES ( Customers[Customer] ) ) )
)
Hi @ChiRomeu
please try
Count =
SUMX (
CROSSJOIN (
SUMMARIZE ( Coutry, Country[Continent], Country[City] ),
VALUES ( Company[Company] ),
VALUES ( Products[Product] ),
VALUES ( Services[Service Type] )
),
COUNTROWS ( CALCULATETABLE ( VALUES ( Customers[Customer] ) ) )
)
thanks a lot!
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
72 | |
30 | |
22 | |
16 |