Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Output Status as Column

Hi All,   In the below table for the first week I worked 40 hours out of 40 so it is billable. Second week same as first week. So for 1st and 2nd week i am Billable. But for third week i worked on...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    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

  • v-lili6-msft's avatar
    v-lili6-msft
    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
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

Mussa's avatar
Mussa
New Member
5 years ago

Dear Power Bi Community,

 

Greetings to all and hope you are safe during this pandemic!

I'm new to this community and I have just completed the registration.

So to start with, I'm unable to produce a simple calculation in power bi, which is way easier to calculate in excel i.e., a specific field rate within the column range.

 

So here is the image of what I need, the left side is the raw table in Power Bi, the summary is in the centre table for illustration and the result needed is in the right side i.e., Closure % (closed divided by total cases of that account). 
Sorry if I'm asking a too-simple question since I'm new to Power BI and still on self-learning 🙂


Appreciate your kind assistance in this matter.

 

Regards,

Musa