topic Re: Single column formula for 2 options Complete and pending in DAX Commands and Tips

Single column formula for 2 options Complete and pending

Imran_1112 — Fri, 01 Dec 2023 12:51:36 GMT

Dear All,

Need help as i am new to Power BI.

To calculate % for in single column with text of (Complete and Pending) by using slicer, click on pending on slicer will give % for pending, when click on complete will give % for complete.

Thanks in advance

Re: Single column formula for 2 options Complete and pending

databi_nerd — Fri, 01 Dec 2023 13:03:23 GMT

Hi Imran_1112 ,

Can you please share some sample data or if possible the .pdix file with required logic?

Re: Single column formula for 2 options Complete and pending

Imran_1112 — Fri, 01 Dec 2023 13:34:29 GMT

Hi, Thanks for your reply,

Below is the text sample of few in that column containing 87 Rows in real, screenshot in below has the slicer for pending, complete and gauge. My aim is when i click on complete values will show on gauge as well as will show the percentage for completed, in other way when i select pending on slicer, it will reflect value on gauge and shows pending percentage.

Please help if its possible. Thanks again.

RFS

Completed

Pending

Completed

Pending

Re: Single column formula for 2 options Complete and pending

databi_nerd — Sun, 03 Dec 2023 06:01:20 GMT

Imran_1112 ,
Please provide some sample data in file.

Re: Single column formula for 2 options Complete and pending

Anonymous — Mon, 04 Dec 2023 02:52:48 GMT

Hi Imran_1112 ,

Below is my table:

The following DAX might work for you:

Measure = COUNT('Table'[RFS])/18

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Single column formula for 2 options Complete and pending

Imran_1112 — Tue, 05 Dec 2023 06:14:26 GMT

Dear Xianda Tang,

Thanks for your reply, Its working well but i need to update total count every time when there is new site added. In your formula /18 has to be change every time when i upload new row or the row count increase.

Is there any way where it counts automatically the total rows (in this case 18) instead of putting manual.

Thanks again

COUNT('Table'[RFS])/18

Re: Single column formula for 2 options Complete and pending

databi_nerd — Tue, 05 Dec 2023 06:30:54 GMT

Imran_1112 ,

I believe the below measure logic will work for you and it's a dynamic logic 🙂

Measure Logic = VAR __AllCount = CALCULATE ( COUNT ( Data[RFS] ), REMOVEFILTERS ( Data[RFS] ) ) VAR __Count = COUNT ( Data[RFS] ) RETURN DIVIDE ( __Count, __AllCount )

If I resolve your issue please accept it as solution.
Thanks

Re: Single column formula for 2 options Complete and pending

Imran_1112 — Wed, 06 Dec 2023 06:25:19 GMT

Thank you very much, it worked what i was looking for. You are amazing man.

Thanks for every 1 who tried to support me.