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 ,
Just rephrasing the below content.
Earlier we created "Billing Status" Pie chart based on "Billing Hours" column.
Now i have created "Utilization Status" Pie Chart based on "Utilization hours" column. (Similar technique followed i.e., same as Billing Status pie chart )
Now the problem when i select any of these Pie chart then the oter Pie chart is not getting associated based on selection.
Provided the Power BI File.
Regards,
Prakash
hi, Anonymous
There are two mistakes in your report:
1. For Dim1 Utilizationstatus, It is "Partiallyutilized" and "Fullyutilized", but in your formula is "Partially utilized" and "Fully utilized", they couldn't match.
2. In UtilisationOutput measure, " Dim1=[Utilizationstatus] " is wrong.
It should be like this:
Best Regards,
Lin
- Anonymous7 years agoNot applicable
As per your comments i updated the dax query, still the chart could not be associated.
Prvided the Pbix file.
https://avacorp1-my.sharepoint.com/:u:/g/personal/yuvaraj_g_avasoft_com/EVTM05iN7CJCp7MW1SNygu0BkOtqEDUbbnedNN_IGk7leQ?e=rsKFHh