Forum Discussion
Output Status as Column
- 7 years ago
hi, Anonymous
You may try this way:
Step1:
Create a Cstatus Dim table(Do not create a relationship with basic table).
Step2:
Then use this formula add a new measure
Measure 2 = IF(SELECTEDVALUE(Dim[Cstatus])=[Measure],COUNTA('Table'[Name]))Step3:
Drag Cstatus field from Dim table and measure 2 into a pie chart.
Result:
here is new sample pbix file, please try it.
Best Regards,
Lin
- 7 years ago
hi, Anonymous
If so, try these two measure:
Measure = CALCULATE(IF ( DIVIDE ( CALCULATE ( SUM ( 'Table'[Billing Hours] ) ), CALCULATE ( SUM ( 'Table'[HoursForWeek] ) ) ) < 1, "PB", "Billable" ),FILTER(ALLSELECTED('Table'),'Table'[Name]=SELECTEDVALUE('Table'[Name])))Measure 2 = VAR _table=SUMMARIZE('Table','Table'[Name],"_discount",[Measure]) var _table2=FILTER(GENERATE(_table,Dim),[Cstatus]=[_discount]) return COUNTAX(_table2,[Name])If you still have the problem, please share your sample pbix file.
Best Regards,
Lin
Hi v-lili6-msft ,
Thanks for your respose. It is working as expected but i want that as column because I would like to see that in Pie Chart.
Regards,
Prakash
hi, Anonymous
You may try this way:
Step1:
Create a Cstatus Dim table(Do not create a relationship with basic table).
Step2:
Then use this formula add a new measure
Measure 2 = IF(SELECTEDVALUE(Dim[Cstatus])=[Measure],COUNTA('Table'[Name]))
Step3:
Drag Cstatus field from Dim table and measure 2 into a pie chart.
Result:
here is new sample pbix file, please try it.
Best Regards,
Lin
- Anonymous7 years agoNot applicable
Hi v-lili6-msft ,
It is working Fine.
Just made a small change in Measure 2. The requirement was Distinct count of Table Name.
Updated Measure 2
Measure 2 = IF(SELECTEDVALUE(Dim[Cstatus])=[Measure],CALCULATE(DISTINCTCOUNT('Table'[Name])))Thanks for your help.Regards,Prakash- Anonymous7 years agoNot applicable
Hi,
when i filter 2 names at a time it is not working.
In the below screenshot i have selected 2 resource and i expected 1 PB and 1 Billable in Pie chart but it is not working as expected.
- Anonymous7 years agoNot applicable
Hi v-lili6-msft ,
Just rephrasing the below content.
I selected May 23 alone in date and i am expecting Prakash as Partially Billable and Nethaji as Billable.
So pie chart should display as 1 - 1 i.e., 50%.
Let me know whether we can achieve this data or not.
Regards,
Prakash