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.
Then I need to add a column in which I make the division of "SalesSale Count" by a DISTINCTCOUNT(Table[DATE]), but I think it cannot, so I have created my own column, called "Manual SalesSaleTh Count" using the COUNT(Table[SalesDate]) function the column created is as follows: (Option "Unsummarised" in the values of the table)
Solved! Go to Solution.
@Syndicate_Admin , A new column = DISTINCTCOUNT(Table[DATE])
will give grand total
in measure DISTINCTCOUNT(Table[DATE]) will give row value
and calculate( DISTINCTCOUNT(Table[DATE]), allselected(Table )) , will give you grand total
what final calculation you need
@Syndicate_Admin , A new column = DISTINCTCOUNT(Table[DATE])
will give grand total
in measure DISTINCTCOUNT(Table[DATE]) will give row value
and calculate( DISTINCTCOUNT(Table[DATE]), allselected(Table )) , will give you grand total
what final calculation you need
I need the value per row, so I tried the DISTINCTCOUNT(Table[DATE]) measure and it worked.
Thank you very much, @amitchandak !
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |