Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good morning, All,
I have a table as seen below called "Fiscal 23." In that table I have multiple columns. Two of which are "Screened By" and "Domain."
I currently have a count of ALL domains totals as a measure.
What I need now is a measure that caclulates the Domain totals less 1 specified user in the Screened By Column.
I will use myself as the example. Notice I have 3 occurrences of my domain in the above table.
I would like the measure to output this:
Notice that there are only four occurrences of domains (minus the three that are tied to the user name "chonchar."
Thank you,
Cam
Solved! Go to Solution.
Hi @chonchar ,
Please try to create a measure with below dax formula:
Measure =
VAR cur_domain =
SELECTEDVALUE ( 'Table'[Domain] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Screened By] <> "CHONCHAR" )
VAR tmp1 =
CALCULATETABLE (
VALUES ( 'Table'[Screened By] ),
FILTER ( tmp, [Domain] = cur_domain )
)
VAR _result =
COUNTROWS ( tmp1 )
RETURN
_result
Add a table visual with field and measure:
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @chonchar ,
Please try to create a measure with below dax formula:
Measure =
VAR cur_domain =
SELECTEDVALUE ( 'Table'[Domain] )
VAR tmp =
FILTER ( ALL ( 'Table' ), 'Table'[Screened By] <> "CHONCHAR" )
VAR tmp1 =
CALCULATETABLE (
VALUES ( 'Table'[Screened By] ),
FILTER ( tmp, [Domain] = cur_domain )
)
VAR _result =
COUNTROWS ( tmp1 )
RETURN
_result
Add a table visual with field and measure:
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Great Solution. Thank you very much.
That measure (which works) only counts the distinct occurrences of the domains.
How would I count the occurrences of each of those domains in my data model and not just the distinct users?
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |