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 friends,
I have the model like this:
I would like count number of row of the table which contains:
I created this measure but it does not work out:
No_Of_Row=
COUNTROWS(
SUMMARIZE(
F_Sales,
D_Date[No Month],
D_Client[Client Name],
D_Customer[Customer]
,"Sales",SUM(F_Sales[Sales])
,"Target",SUM(F_Target[target])
))
Could anyone please help me to solve it?
Much appreciate your help.
Hi, @tracytran91
Although there are relationships between your model tables, the target and sales tables are not related, and the three dimension tables are not related, so your code can't be written like this...
@tracytran91 , Try a measure like
countrows(F_sales,D_date[Month], D_customer[Customer], C_Client[Client Name] ,"_1" , sum(f_sales[sales]), "_2", sum(F_target[target]))
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |