Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
i am in need of assistance, i am creating a dasboard which has a table visual which includes columns from different tables and different measurements.
i have been able to get my desired output which is to get top 10 clients based on their premium which works fine when my table visual only has columns but as soon as I add a measure it stops working.
i am using the following measures for ranking slicer
GROSSPREMIUMRANKVALUE = //RANKS PREMIUM OF CLIENTS IN THE TABLE VISUAL//
RANKX(CROSSJOIN(ALL(DETAILS[CLIENT_NAME],DETAILS[POLICY_NUM],DETAILS[EFF_DATE],DETAILS[EXPIRY_DATE]),ALL(PARNTER_DETAIL[REGION])),[GROSS_PREMIUM],,0)
SelectedTopNValue = //SELECTED RANKS VALUE IN THE TABLE VISUAL//
IF (HASONEVALUE(RANK_SLAB[SLAB]),VALUES(RANK_SLAB[RANK]),MAXX(VALUES(DETAILS[POLICY_NUM]),[GROSS_PREMIUM]))
Where RANK_SLAB is a table for rank values
GROSSPREMIUMVALUE = //measure added in table visual to display gross premium//
IF([GROSSPREMIUMRANKVALUE]<=[SelectedTopNValue],[GROSS_PREMIUM])
The result is perfect that shows 20 top gross premium clients
but as soon as i add a measure in visual it displays all the rows
how can i fix this issue, even i add measures in the visual it shows only the selected top 20 rows.
thanks and regards
ssw
Solved! Go to Solution.
the measure which returns the rank also needs to be added to the visual filter and then simply filter values <=10
any idea how can i do the same thing for percentage column
CLAIMRATIORANKVALUE =
RANKX(ALL(DETAILS[POLICY_NUM]),[CLAIM_RATIO],,0)
SelectedTopNCRValue =
IF (HASONEVALUE(CLAIMRATIORANK_SLAB[CLAIMRATIOSLAB]),VALUES(CLAIMRATIORANK_SLAB[CLAIMRATIORANK]),MAXX(VALUES(DETAILS[POLICY_NUM]),[CLAIM_RATIO]))
CLAIMRATIOVALUE =
IF([CLAIMRATIORANKVALUE]<=[SelectedTopNCRValue],[CLAIM_RATIO])
currently its working great when using slicer but when i remove the slicer it does not display all values as the [claim ratiovalue] measure should
when i apply the filter
any idea how can i do the same thing for percentage column
CLAIMRATIORANKVALUE =
RANKX(ALL(DETAILS[POLICY_NUM]),[CLAIM_RATIO],,0)
SelectedTopNCRValue =
IF (HASONEVALUE(CLAIMRATIORANK_SLAB[CLAIMRATIOSLAB]),VALUES(CLAIMRATIORANK_SLAB[CLAIMRATIORANK]),MAXX(VALUES(DETAILS[POLICY_NUM]),[CLAIM_RATIO]))
CLAIMRATIOVALUE =
IF([CLAIMRATIORANKVALUE]<=[SelectedTopNCRValue],[CLAIM_RATIO])
currently its working great when using slicer but when i remove the slicer it does not display all values as the [claim ratiovalue] measure should
when i apply the filter
the measure which returns the rank also needs to be added to the visual filter and then simply filter values <=10
Thanks a lot @Pascal_KTeam 😃
in the visual filter changed the measured column to "is not Blank" and it works perfectly.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |