Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i have a graph with each category displayed as percentage of total. when i select top 10 in filter it changes the percent to the top 10 only.
is there anyway of keeping perctage of coloumn total.
Solved! Go to Solution.
Hi @NewbieJono ,
I created some data:
Here are the steps you can follow:
1. Create measure.
rank =
RANKX(ALL('Table'),[category_percentage],,DESC)
Flag =
IF(
[rank]<=10,1,0)
2. Place [Flag] in Filters, set is=1, apply filter.
3. Result:
By tagging and filtering it, the filtered percentage is still calculated by the total amount
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @NewbieJono ,
I created some data:
Here are the steps you can follow:
1. Create measure.
rank =
RANKX(ALL('Table'),[category_percentage],,DESC)
Flag =
IF(
[rank]<=10,1,0)
2. Place [Flag] in Filters, set is=1, apply filter.
3. Result:
By tagging and filtering it, the filtered percentage is still calculated by the total amount
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This is what i have now to
Total Failures =
VAR
TOTALFAIL = CALCULATE (
SUM('FACT - Error Data'[ALL]),
FILTER('FACT - Error Data','FACT - Error Data'[FAILURE REASON]<> 51 && 'FACT - Error Data'[FAILURE REASON]<> 52)
)
RETURN
TOTALFAIL
---------------------------------
Total Transactions =
VAR
totalIntefrity = CALCULATE (
SUM('FACT - Integrity Data'[VOLUME]),
filter('FACT - Integrity Data','FACT - Integrity Data'[CODE]="TTE.02")
)
VAR
totalError = CALCULATE (
SUM('FACT - Error Data'[ALL]),
FILTER('FACT - Error Data','FACT - Error Data'[FAILURE REASON]= 51 || 'FACT - Error Data'[FAILURE REASON]= 52)
)
RETURN
totalIntefrity - TotalError
---------------------------------------
Daily Percentage Failure Rate = [Total Failures] / [Total Transactions]
you have to remove filter from percentage with help of dax by using ALL Function on the percentage column
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
any examples how i could do this
can you share the dax please
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
i not using DAx, i just got total counts and display total as %