The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |