March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello folks,
I am struggling with what I thought should be simple. I m ranking the clients as per the below :
The problem is I want to count the the number of clients by theire status.
The Dax are as the below:
Solved! Go to Solution.
Hi @Baroumy
Manually insert a single column disconnect table that contains all statuses (unique list of statuses). Place the new column in a table visual along with the following measure.
Count =
SUMX (
CROSSJOIN ( VALUES ( 'Table'[Code] ), VALUES ( Status[Status] ) ),
INT ( [Client Status] = Status[Status] )
)
Hi @Baroumy
Manually insert a single column disconnect table that contains all statuses (unique list of statuses). Place the new column in a table visual along with the following measure.
Count =
SUMX (
CROSSJOIN ( VALUES ( 'Table'[Code] ), VALUES ( Status[Status] ) ),
INT ( [Client Status] = Status[Status] )
)
Hi @tamerj1
So I should do the first step in the query editor by clicking the "enter data" button and creating a new table named list of status and manually entering the 4 statuses?
PS: I need to use the total counts in a single card visual.
@tamerj1 ,
Thanks al lot.
However the total are wrong, I believe it is due to the [year of sales] and [year of sales PY] measures and the dates filter.
Below are the results :
The existing count is 0! it shoudl be 288.
@Baroumy
Try to select a year in a slicer to see what happens. Also I did not understand what is the problem with the total?
*EDIT
Check the spelling of Existing and make sure it matches 100%. It could be a space.
Thank you @tamerj1 .
The problem was I am relying on the client codes coming from each year's transactions. I added a client list table and I guess the problem is solved.
thank you.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
21 | |
14 | |
11 | |
8 | |
5 |
User | Count |
---|---|
24 | |
21 | |
20 | |
15 | |
10 |