(06-08-2021)_ResearchPurpose_Status.pbix (8.0 MB)
Hi,
I would like to show the statuses in the visual as the image below
In the SABS, there are three statuses(Approved, Disapproved, Submitted - not reviewed) but in the SAS-Radio there is only one Status i.e. Approved, I would like to show all three statuses whether there is any status or not like
SABS
Status
Approved 22%
Disapproved .6%
Submitted -not reviewed .6%
SAS-Radio
Status
Approved 57.82%
Disapproved 0%
3 Submitted-not reviewed 0%
Hope the requirement is clear, please let me know if you need any further clarification.
Next set up a measure that will return a 0 for items with no values, for example:
# of Survey v2 =
VAR myCount = COUNT(Survey[packageStatus])
RETURN
IF( SELECTEDVALUE( 'Package Statuses'[Package Statuses] ) IN { "Approved", "Disapproved", "Submitted-Not Reviewed" },
myCount + 0,
myCount
)
Note that I passed the 3 specified values explicitly { âApprovedâ, âDisapprovedâ, âSubmitted-Not Reviewedâ } in this measure. You could replace that with ALL(âPackage Statusesâ[Package Statuses] ) but that will return all other items present in your DIM table as well.
Hereâs the result.
You can repeat this for %ages.
I hope this is helpful.