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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Jdiep
Helper I
Helper I

Calculation shows more than 100% in linegraphwith date axis, but not in card

Hello hello,

 

Been struggling with the following issues for couple of hours now and was hoping you guys can help me out. Situation is as follow

 

I have a few measures that excist of a simple devision displayed as a percentage. 

Example:  /Eerste gesprek = iferror([Aangenomen]/[Eerste gesprek];BLANK()) Where Aangenomen means amount hired and Eerste Gesprek means First intake

 

When I display the result as a card it will give me the correct percentage of 38%. The moment I plot these calculation in a line graph with X-axis the JobApplicationDate it goes haywire. See attachted image for the result. 

 

When the issue first came to light it also included infinite values, but I corrected those errors by implementing IFERROR in the DAX. Also my date slicer (with JobApplicationDate as field) didn't populate 2021 automatically, it stopped itself at 31-12-2020 eventhough the model clearly showed it had data from 2021. SO I removed that so it wouldn't create issues

 

Solutions I have tried

- implementing IFERROR in DAX

- Creating a datetable and connecting that table with a relationship to JobApplicationDate, result was the same

- Use DIVIDE instead of just "/"

 

I am definitetly not claiming that the solutions I have tried were absolutly correct, so if one of these is the way to go I would love to hear you guys take on it. 

 

Hope someone can help me out.

Snapshot 13-01-2020.png

 

1 ACCEPTED SOLUTION
Jdiep
Helper I
Helper I

I have solved this issue. There was a broken filter in our API connection with the platform. This made sure that the data did not come through correctly and thus broke the measure. 

@Amit Thank you for your efforts anyways

View solution in original post

4 REPLIES 4
Jdiep
Helper I
Helper I

I have solved this issue. There was a broken filter in our API connection with the platform. This made sure that the data did not come through correctly and thus broke the measure. 

@Amit Thank you for your efforts anyways

amitchandak
Super User
Super User

@Jdiep ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Let me know if this enough to analyze with. I can see what i possible within my companies limits to give you some more.

 

Id; Bucket; cxsrec__Job_application_date__c
a0d1n00000frlK8AAI; Afgewezen; donderdag 13 februari 2020
a0d1n00000gfALHAA2; Aangenomen; vrijdag 6 november 2020
a0d1n00000gfjbFAAQ; Aangenomen; donderdag 17 december 2020
a0d1n00000gek0LAAQ; Aangenomen; vrijdag 9 oktober 2020
a0d1n00000gMeSCAA0; Aangenomen; dinsdag 28 april 2020
a0d1n00000gO1jRAAS; Aangenomen; vrijdag 17 juli 2020
a0d1n00000gNDX8AAO; Aangenomen; dinsdag 19 mei 2020


Id; cxsrec__Job_application__c; cxsrec__New_workflow_status__c; Bucket
a0x1n000005cnegAAA; a0d1n00000gfALHAA2; a130Y000000HgYAQA0;
a0x1n000005coDEAAY; a0d1n00000gfALHAA2; a130Y000000HHRaQAO;
a0x1n000005cnyXAAQ; a0d1n00000gfALHAA2; a130Y000000HHRcQAO; AVW
a0x1n000005cnxKAAQ; a0d1n00000gfALHAA2; a130Y000000HHS4QAO; Tweede gesprek
a0x1n000005cnebAAA; a0d1n00000gfALHAA2; a130Y000000HHRZQA4;
a0x1n000005cjB9AAI; a0d1n00000gfALHAA2; a130Y000000HHRzQAO;

Jdiep_0-1610619425131.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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