Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am new here and I need help.
I would like create a mesure where I can combine the number of rows of one column (A) and the numbers distincts values for another column (B).
I was able to create a mesure that shows the numbers distancts values (column B):
Total Distinct value B =
IF (
HASONEFILTER ( 'Calendar'[Month Name] ),
CALCULATE ( DISTINCTCOUNT ( 'BB List'[column B] ) ),
SUMX (
ALLSELECTED ( 'Calendar'[Month Name] ),
CALCULATE ( DISTINCTCOUNT ( 'BB List'[column B] ) )
)
)
Unfortunatelly I can't find a formula that I can combine the two requests...
This is an example of the table
Someone can help me?
Did not get it completely
Try
Measure = countrows(table)+distinctcount(table[column B)
Measure = count(table[column A])+distinctcount(table[column B)
Hi @amitchandak
Thank you but it is not what I really need.
I need to filter the column email with only distinct resultants and count the values of the job board column.
Do you have any idea?
I created a link that you can have access to the sample of the same structure that I have in my file. Some information are confidential so I needed to change a bit. But the structure still the same.
Link(we tranfer): Sample data
In this example we have:
28 emails
7 jobat
7 Monster
14 Stepstone
The result that I expect is:
(22 distincts emails in total)
When I select in my sicler the job board, I expect see these results
6 jobat
5 monster
11 septs
I hope that you can help me.
Thank you!
Can you create an example display and explain.
If I take email, restaurants in the matrix, it will display distinct restaurants. What do you mean by filter email by distinct restaurants?
Hi @Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |