Solved: How to create a custom total for the data to be re...

Stabbathehut · ‎10-03-2019

Currently, the total is the cumulative total of all data. However, I would like the total to be 57 as some members have multiple skills meaning when using a pi chart visualisation, the percentage should be out of 57 rather than 123

v-shex-msft · ‎10-03-2019

HI @Stabbathehut ,

You can write a measure with filters to calculate with specific users. If you are confused about the coding formula, can you please share some sample data for test?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

v-shex-msft · ‎10-03-2019

HI @Stabbathehut ,

You can write a measure with filters to calculate with specific users. If you are confused about the coding formula, can you please share some sample data for test?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

How to create a custom total for the data to be represented in a Pi Chart

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly