Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
So I have a scenarion that requires me to calculate the total number of "distinct transactions" per employee role.
eg. I have the following role titles
1. floor sales rep
2. snr floor sales rep
3. mobile sales rep
4. snr mobile sales rep
5. online/tele-sales rep
I would like to count the total number of transactions that each role does daily.
I have used the following formula
Total Trxns per Employee Title =
Calculate(DISTINCTCOUNT( 'FACT_DAILY_SALES'[SYS_TRXN_ID]), filter('FACT_EmployeeTable',FACT_EmployeeTable[EmployeeTitle]))
There doesn't seem to be an error in the formula but when i add the measure to the visual I get the following error
<<Calculation error in measure 'Sales_Measures'[Total Trxns per Employee Title: Cannot convert 'floor sales rep" of type text to type True/False.>>
Would anyone here be able to assist me with a solution.
Thank you
Solved! Go to Solution.
Hi,
you can try a calculated column
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Thanks for the suggestion, however when I attempt it, the formular requires that the statement
var currEmployeeTitle = FACT_EmployeeTable[EmployeeTitle] use a measure in place of FACT_EmployeeTable[EmployeeTitle] so unfotunately it did not work, unless I am missing something.
Hi,
are you sure of having choosen a calculated column and not a measure?
Hi,
you can try a calculated column
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
63 | |
56 | |
27 | |
17 | |
13 |