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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Showing sum after re-entering sliced report

Hi,

 

When I enter the report in default settings my cluster column shows the following values:

default setting.PNG

 

After using the slicer on the report page it will show the correct numbers.

 

However, when leaving the report (with activated slicer) and re-entering it. The cluster column will show the following values:

verkeerde setting.PNG

 

I don't understand where this is coming from. I can solve it by using the "reset to default" button.

However, it is not how it is supposed to function. 

 

Please ask if anything is unclear.

 

Kind regards,

Guido 

 

4 REPLIES 4
v-frfei-msft
Community Support
Community Support

Hi @Anonymous,

 

Could you please share you sample data of your table to me and tell us the version of your Power BI Desktop?
As based on my test, everything goes well and I cannot reproduce your issue in Power BI Service.

 

Regards,

Frank

 

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

Hi @v-frfei-msft

 

How I created the table can also be found at this topic: http://community.powerbi.com/t5/Desktop/Create-column-filled-with-measures/m-p/325596#M145213

 

The last update of my power BI desktop was after the June 2018 Update.

 

Sample data:

 

Representative (used in the slicer)

Representative
Representative A
Representative B
Representative C

 

Visit reports:

Rep codeCompanyType
1111Company AAcquisitie
1111Company BROS
1111Company CRelatie beheer
1111Company DContractverlenging
1111Company EAcquisitie
1111Company FROS
2222Company GRelatie beheer
2222Company HAcquisitie
2222Company IAcquisitie
2222Company JROS
2222Company KRelatie beheer
2222Company LAcquisitie
3333Company MRelatie beheer
3333Company NAcquisitie
3333Company OContractverlenging
3333Company PROS
3333Company QAcquisitie
3333Company RRelatie beheer

 

Translate:

RepresentativeCode
Representative A1111
Representative B2222
Representative C3333


 Goals:

RepresentativeTypeGoal
Representative AAcquisitie20
Representative AROS10
Representative ARelatie beheer30
Representative AContractverlenging5
Representative BAcquisitie20
Representative BROS10
Representative BRelatie beheer30
Representative BContractverlenging5
Representative CAcquisitie20
Representative CROS10
Representative CRelatie beheer30
Representative CContractverlenging5

 

Type 

Type
Acquisitie
ROS
Relatie beheer
Contractverlenging

 

I am using the clustered column chart:

Axis:

- 'Type' [Type]

 

Value: 

- Calculated measure (Count visit): 

CALCULATE(COUNT('Visit report' [Company]); USERELATIONSHIP('translate' [Code];'Visit report' [Rep Code]))

- Calculate column (Target PM)

('Goals' [Goal]/12)*MONTH(TODAY())

 

I don't know how to sent a pbix file on here. Otherwise I can create a sample file.

 

Hope you can help me any further!

 

Kind regards,

Guido 

Hi @Anonymous,

 

I used this version 2.36.4434.362 64-bit (June 2016)  to make a test using the data as you shared. Is the version Number same as yours? Unfortunately, I still cannot reproduce the issue. So you can ask for help to open a ticket from here.

 

Regards,

Frank

 

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

Allright, Thanks for your help!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors