DAX help with data buckets

Anonymous — Wed, 24 Jan 2024 17:16:48 GMT

I have a Power BI report that is sourced from an SSAS model.

I have an alert table that is at the device level and has a record for each alert from a device.

I have these measures:

A count of the average number of devices that send an alert in the given date range (defined by a date slicer in the report)

An average percentage of the number of devices that send an alert in the given date range

Percent buckets (a switch statement to assign a bucket to the above measure, 0-25, 25-50, 50-75, 75-100)

I have a table that holds the device informaton which has an inactive bi-directional relationship with the alert table.

My final table is a mapping of device to customer which has a bi-directional relationship to the device table.

What I would like to do is have a chart/table that shows the number of customers that fall into each percentage bucket. For example, customer A had 35% of its devices send an alert in the given date range, so it would be in the 25-50 bucket.

I have a measure for the customer count which does a distinct count of customers from the customer table, and I use the inactive relationship between the alert and device tables. This gets me the total count that I am looking for.

If I create a table with the percentage bucket, customer number and customer count the data is displaying correctly. Obviously, with the customer number in there the customer count is 1 for every record. When I remove the customer count the table shows only the lowest percent bucket, 0-25, and shows the total count for the customer count measure. It does not "group" the accounts by the percentage buckets.

Any help on this is greatly appreciated.

Re: DAX help with data buckets

lbendlin — Thu, 25 Jan 2024 01:00:07 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic DAX help with data buckets in DAX Commands and Tips

DAX help with data buckets

Re: DAX help with data buckets