Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

BIns with calculated measure and customers

Hello world, 
I got an issue with creating bins. 
I want to create a histogram showing the amount of clients existing in a specific category of difference between 2 colums. 
So I have created a measure :

UNAP AP Dif =
CALCULATE(COUNT('Sales'[Receipt Id]),filter('Sales','Sales'[Application Status]=="UNAPP"))-CALCULATE(COUNT('Sales '[Receipt Id]),filter('Sales','Sales'[Application Status]=="APP")). 
This is used to create a view 
 

Untitled.png

So, I would like to create a histogramm with a group of customers in category with difference of 3, another one of difference of 2 etc etc. I tried right click group but nothing. I use analysis services so I have no access to the queries and I cannot also share a file. 
Any ideas?
Thanks world!

2 REPLIES 2
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Unfortuantely as it is a file connected with Analysis services I cannot create such a file, I know it would be ideal,.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.