Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I wanted to calculate the number of distinct rows that are present based on a few columns and take only the values whose dates are
maximum for each month.
example:
aug - 5 | 20 |
aug - 10 | 25 |
aug - 29 | 30 |
july - 15 | 10 |
the result is
aug | 30 |
july | 10 |
I have writen the dax for it,
CALCULATE(
COUNTROWS(
DISTINCT(SELECTCOLUMNS('table',"Id",'table'[Id],"StateName", 'table'[StateName], "LoadDate", table'[LoadDate]))),FILTER('table','table'[Score]>0 && 'table'[date_number]=max('rpt VwFPODigitizationScorepivot'[date_number])))
but the grand total is incorrect, so it becomes incorrect when i take percentage of row total.
How can i get the correct grandtotal as = 97+84 = 181
Thankyou
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please try to write a new measure something like below, and replace a current measure with the new one.
New measure: =
SUMX ( VALUES ( calendartable[month_name] ), [your current measure] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but please try to write a new measure something like below, and replace a current measure with the new one.
New measure: =
SUMX ( VALUES ( calendartable[month_name] ), [your current measure] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you, didn't think in this way that I could write another measure to achieve the result.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
30 | |
22 |